I think the ProtonDB mixed ratings are because there are plenty of old review and people do not update much VR games. I have been using Steam VR and HTC Vive with Linux for a while now, and I remember when Creed and a couple of other games would not work. I think about 5 years ago, with Proton 5.13, that changed and since then, pretty much everything works.
My only problem is with Steam VR software that is a bit inconsistent. I used to do a bunch of stuff with it, now I just launch the games and avoid it when I can.
MacBooks with intel chip are some of the best hardware to put Linux on, there are plenty of guides online on how to liberate your MacBook with Linux.
I tested a bunch of distros based on Debian, Arch and Fedora. By far, the easiest one was EndeavourOS just because it recognized the WiFi driver from the Live USB for me. Otherwise you will need to use a mobile phone with USB tethering to share internet so you can install the broadcom driver. Maybe things changed, but this was my experience in 2023.
Another driver you will need to install is the camera facetimehd . Everything else worked out-of-the-box for me.
After that, all the Linux variants I tried worked great, and it was mostly about distro philosophies and deciding the desktop environments (DE) I wanted to use, and that can be a bit overwhelming at first.
If that is your first experience, I just recommend to start with KDE or gnome. I find gnome works ok from the start, but KDE is easier to tweak. You can always test them from a Linux Live USB before committing them to your hardware. Steam Deck uses KDE for desktop mode.
There are others that are prettier or lighter you can test too: cinnamon, XFCE, MATE. Or even windows managers, but I would leave them alone until you are a bit more comfortable with Linux.
here are a few links in case some people need it in the future: