>>289393104
Skyrim VR is a plugin for the special edition, so (almost) all mods that work for the special edition work there.
Fallout 4 nexus has a VR section for mods, so I assume it's the same case there, but it was so irredeemably shit that I've never bothered trying.
All of the Bethesda VR games are objectively bad ports. You can still have some fun in Skyrim with bows/magic, but melee combat is just waggling mapped to clicking your mouse.

I'd recommend you play Alyx first to get your legs, then maybe branch out to Asgard's Wrath or Stormlands for the open world experiences you want.