But that is mostly caused by NVidia's lackluster (yes, I know they are improving somewhat, but still) driver support in Linux.
I had to dick around with config files again with the recent driver "improvements" to make suspend work (I had to fiddle with persistenced) so yeah, I agree that Nvidia drivers for Linux do suck, but I don't think that's the primary thing keeping Windows going. I would lean on the following two words: Inertia, and Anticompetitive. Write your own story, it's pretty obvious by now.
Not even good ones or modern GPUs, but GPUs you would expect the kernel to support for several years already.
I don't want to poop on Nouveau, but it's just not useful. It's not their fault, as they are mostly pooped on by Nvidia. IME closed Nvidia drivers are better than closed AMD drivers, but the open AMD drivers are very good.
Sure, there are "gaming"-distros and the main distros (+ derivatives) might work ok-ish with NVidia GPUs, I'm already aware.
In fact I now have my 4060 Ti working very well with Devuan with root on ZFS and kernel 7.1.8... but it's been a PITA. I've heard something about Steam going fully 64 bit but I might still be using non-WOW Wine, so I might still need 32 bit libraries for other things. I mention this because I do not use packages for Nvidia drivers, I install them (and CUDA) from the runfile. This works flawlessly on Debian et al, and also solves the problem of the driver packages conflicting with multiarch.
(If anyone is curious, putting options nvidia NVreg_PreserveVideoMemoryAllocations=1 NVreg_TemporaryFilePath=/someplace/persistent into /etc/modprobe.d/nvidia.conf fixed my sleep problem. There were some other steps, but they were system-specific.)
This is the first time I have regretted getting Nvidia graphics. CUDA is still great, though.