Personally my peak VR experience has been playing the Outer Wilds with a PC VR mod, but very hardware dependent to get decent framerates.

Wanderer might be a good option for you if you're looking for a puzzle game with a bit more story meat to it.

I think a lot of VR games end up short and sweet not just for technical & cost limitations but because the extra effort and intensity of the VR experience means players can get burnt out on longer story focused games. I remember Valve talking about how they had to really change up the pacing of their standard formula when they were developing Half Life: Alyx.