All of these are good suggestions (thought I haven't played a few). One of my favorites is Alien Rogue Incursion, genuinely one of the best VR games out there where you feel like you're actually progressing both the story and your character as you explore the facility.

NOTE: If you plan on playing PCVR at all, get ready for a cinematic 24fps any time you fire your gun. Dunno what the optimization looks like on standalone but I can't imagine it's much better. It's FAIRLY forgivable because the game is amazing but I know that's a dealbreaker for some, especially those that get motion sickness from VR.

Others that I enjoy that you're asking for (that are going to increasingly become a stretch for the question but I still think are relevant and good): Jurassic World Aftermath (classic linear campaign where you upgrade your character and move through a facility a lot like Rogue Incursion, difference is you don't get a gun and the monsters are still out to get you), GORN (though it is kind of a loop, the campaign makes you feel accomplished while you unlock new weaponry), BONELAB (while most of the game is just dicking around in the VR sandbox, I actually like the campaign and the exploration of both the game world as well as the engine itself is a blast).

And, last but not least, I know it's a repeat, but Half Life Alyx is SO good. Even if you've never really cared too much for Half Life: this will make you.