I'll never buy an Oculus/Meta headset given that it's owned by Facebook.
As for my VR experience, I have the first PSVR and honestly, it kind of ruined me on VR. It's not that it was bad by any means. It simply taught me that I have a low tolerance for VR. Unless I'm standing still in the game, I tend to get motion sick anywhere from 30 seconds to 20 minutes depending on the game.
As an example, Rise of the Tomb Raider had the ability to explore Lara's mansion in VR. The walking was so horrible, making me sick in seconds. Luckily, they had a "warp" feature allowing the user to instantly appear to a point to look around instead of walking there. RE7 on the other hand had the walking down much better and I could tolerate closer to 20 minutes. If I was in a vehicle in game, I didn't get sick as much for some reason. I expect that was due to my brain understanding that I'll be sitting in a vehicle while in motion?
My favorite VR games were Moss, Star Trek Bridge Crew, and the experience ones where you go diving under the ocean. In all of them, the player was basically still, looking around.
I've no plans on buying PSVR2 as none of my PSVR games will work on it and it's insanely costly atm.