I totally agree with you, I'm actually doing another Alyx run after only playing it on my Index. It actually please extremely well on the Quest 3 with the Steam Link app. Seamless.

This guy on X gave me some suggestions of top tier VR games:

Hubris, Into The Radius, Wanderer, Blade & Sorcery, RE4 Remake, Modded Skyrim VR, Modded Minecraft, Vertigo 2, Arken Age, Half Life 1 & 2 VR, UNDERDOGS, Hitman VR, Pixel Ripped Series, Walking Dead, Propagation Paradise Hotel

Hitman is amazing insofar as the worlds are so well realised and the gameplay is excellent. But the controls are a bit pants, and I had an issue on Quest three where it was applying a foveated rendering but the mask was off (and the quest 3 doesn't have eye tracking). So it was blurry within my field of view, and sharp just next to it.

Various random and unexpected indie games exist. Like the Indie community has fully embraced VR and it is full of unique and experimental and awesome and garbage games.

Euro and American Truck Simulator still have VR support and it's more fun and satisfying than it should be.

Load up Google Earth VR, plop yourself in front of your childhood home and feel more than you expected.

If you like modern air combat: VTOL VR and DCS. If you like WW2 fighter combat, IL-2 Sturmovik.

Hotdogs Horseshoes and Handgrenades for the ultimate American Freedom simulator.

Project Wingman for Ace Combat 7 in VR. Star Wars Squadrons is fully playable in VR. War thunder has VR

BeamNG has unofficial VR

Rec Room if you want to get absolutely schooled by 13 year olds at laser tag and paintball and other games.

Hyperbolica is an exploring and puzzle game about non-euclidean space, where walking in a straight line doesn't work like you expect and apparently it has VR

Pulsar Lost Colony is a game about being a star trek captain with your friends and also can be played without VR.

Phasmaphobia is a game about getting the shit scared out of you and you can do it in VR if you do not fear death

An upcoming game about "Be an artemis astronaut". There was also one to explore a Google Earth style of the ISS. Also Kerbal Space Program at one time had a VR mod.