The "Nvidia on Linux compatibility" issues are something I wonder if I have side-stepped somehow either by lucky choice of GPUs, or lucky choice of Linux distros.
Was/is this a distro thing, or an actual issue?
Every Nvidia I've used [1] has worked perfectly, from the change for Xfree86 to Xorg, through the Compiz desktop wobbly window craze, to the introduction of GPGPU APIs like CUDA/OpenCL and recently Vulkan.
I do recall once helping a friend setup a Debian and a Ubuntu machine with Nvidia (which I never used before) and it took some figuring-out of how to install non-free drivers, so maybe my choices of Gentoo and Arch (not being as conservative towards non-free licenses as Debian/Ubuntu) always made it a non-issue?
[1] 6800 Ultra, 7800 GTX , 7900 GTX, 8800 GTX, GTX 280, GTX 480, GTX 680, GTX 760 Ti, RTX 2080, RTX 4080... probably missed some.
I've also never had any trouble with NVIDIA on the desktop. I think most issues people have are on laptops, which have odd hybrid/dual GPU setups, and which exercise suspend/hibernate much more aggressively.
If you have sufficiently old Nvidia GPUs, eventually drivers and supporting software stops shipping with distros. I have a bunch of older laptops that support in Ubuntu existed for like 10 years ago, but drivers stopped being updated and Ubuntu dropped them from their repos.
We've had open source AMD drivers for... 20ish years now? Meanwhile Nvidia begrudgingly added drivers support in the last year or two. So maybe some recency bias.