unless you're a hobbyist into simulators aka things like iracing, assetto corsa, il-2 sturmovik, dcs world where you already own a steering wheel kit or HOTAS and want a VR headset purely for deeper immersion, into multiplayer shooters like pavlov and outward where the main selling point is the physicality of handling weapons or into rhythm games which basically treat the platform as a more technologically advanced kinect then it's slim pickings
when it comes to linear singleplayer shooters you've got boneworks (which is also on the oculus store in case you don't wanna tether every time you wanna play), raw data and alyx for pcvr and, like, robo recall and zero caliber which are oculus store exclusive and both of those are more "replay the same levels doing dumb shit with different weapons" than actual linear campaigns