I’ve been using Linux full time on my desktop since 2019 and while I don’t think I’ll buy nvidia again, the experience in the meanwhile has been fine. The things I can do with my computer are much more limited, especially when it comes to Wayland. But assuming you’re just using your computer like a normal person you can stick to Xorg and basically have a totally normal computer experience.
Personally, one of the worst parts about nvidia proprietary drivers with Wayland is that I cannot use the night light feature in Gnome, which makes my display unreasonably uncomfortable during night time usage. When will nvidia provide the necessary support for the thing that makes it work? Who knows.