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.