I’ve had a CV1, Rift S, Quest 1 & 2, Vive Pro 2, Reverb G2, and as of today a Quest Pro, so I’m pretty well placed to give advice.
I’ve also got a similar system 10850k, 32 GB ram, 3090 set up.
Of the headsets I’ve tried I’d recommend the following three, with caveats.
Quest 2 - Best all rounder and value for money. This headset has decent controllers and tracking, and is the one to buy if you want a bit of everything, standalone VR, PCVR action/roomscale titles, Half Life Alyx, Saints and Sinners etc. If you get the official USB-C link cable and ramp up the resolution to 5408 x 2736 you’ll be surprised how good this can look for PCVR. I actually preferred it to the Vive Pro 2 which cost £1400 for the full kit. It’s isn’t comfortable though, and its visuals cannot match the G2, especially for MSFS.
Reverb G2. Best value headset for MSFS, This has great visuals, decent colours and really good central clarity. As you have noticed already its sweet spot is small however, things rapidly get blurry away from the centre of the screen. I’ve not had a problem with heating however. The revised cable has an off switch so you can turn it off, and I wouldn’t consider the cable fragile at all. I’m on Nvidia so can’t comment on AMD compatibility. If you buy the VRCover facial interface, it’s a lovely comfortable headset, and has really good audio, best in class.
Quest Pro. This headset is rather monstrously priced so I wouldn’t recommend it just for MSFS but I have to say after a bit of a ropey start with it charging when I got it today I’m really starting to love this headset for PCVR.
The lenses are hands down the best I’ve ever used. There’s no god rays, glare or distortion and the lenses have almost true edge to edge clarity. This is the first headset I’ve ever thought good enough to watch movies or browse the web. It also has a great FOV, if you cram it close enough to your face it’s almost as wide as the Vive Pro 2 whilst having a vertical FOV similar to Quest 2, it’s very, very nice.
In standalone mode the resolution isn’t that impressive, but with the USB-C link cable I can max it out at 5408 x 2736 and it looks insanely good. It’s basically like the Reverb G2 with edge to edge clarity.
The lack of a display port and slightly lower resolution than the G2 don’t actually matter when you’re viewing inside the headset, it’s much better visually than the G2, even for MSFS, and with a much better FOV.
In the Cessna 172 I can finally see the entire cockpit in one field and view and I only need to move my eyes not my head. It looks so much better overall,
I’ve not tried the Varjo Aero, but if it has lenses like this, and the much higher resolution and display port it must look absolutely insanely good.
Personally if it’s just for MSFS I’d go G2 as it’s super affordable. The Quest 2 is a great all rounder, but if , like a lot of people you end up buying both, at that point you might just as well get the Quest Pro instead as it’s miles better than both the G2 and Quest 2.
It’s easily the best headset I’ve ever used, and the only PCVR headset I’d consider over it would be the Aero, but that’s £2700 once you’ve bought the headset, basestations and controllers, so makes the Quest Pro look pretty affordable.