My experience, playing Odyssey... I don't do any of the FPS stuff as that isn't my thing, but I do get out of my ship and walk around on planets from time to time. As others have said, you get great 3D headlook VR in your ship and SRV, on foot is a poor VR experience - well not a VR experience at all.
I was using a Reverb G2 (V1) for ED and MSFS. I have an i7 10700K, RTX 3080, 32GB and a 1TB SSD. I used Steam VR for playing ED and reduced resolution a bit in the steam VR settings for ED. My graphics settings in ED were a custom mix (I'll see if I can find a link to them) and performance was Ok. I don't constantly monitor FPS, but it felt smooth and text and the HUD were lovely and sharp. The downside was that I would get occasional very bad stutters, opening the galaxy map, sometimes arriving in a system after a hyperspace jump.
My G2 broke... So I got a Quest 2 which I run through the Oculus software and the link software - meaning I'm connected to the PC using the USB cable, which I find a bit flaky, it has dropped out a couple of times, but that's Oculus, not ED. I can run ED graphics at VR Ultra, it's smooth, no stutters at all, but it's not as clear as the Reverb was. Certainly clear enough for my eyesight, and I'm out exploring, haven't tried combat with it yet.
Would I go back to the G2 if I choose to get another one? It's a toss up for ED. I would for MSFS I think as the clarity is quite a bit better with the G2 on that, but for the lack of stutters in ED I might just stick with the Quest 2.