Debian based distro is usually better but not always. As can be seen here:This can be the case, but in distribvutions that have properly implemented DKMS, it shouldn't.
(and there is no reason for any distribution to not have done this by now)
DKMS "just works" in the Debian tree of distributions.
The drivers are less featured than under Windows, and perform slower, but they do indeed "just work" as modules are automatically and successfully built every time the kernel changes.
It might break with some weirdo kernel from outside the official distribution repository, but in general it is a bad idea yo use any software from outside the official repos.
It's not a horrible experience mind you. But it's leagues behind when the driver is bundled with the distro. I found the performance of the Nvidia drivers under Linux actually to be quite close to their Windows counterparts. Usually within a couple of percentages.
Back to the issue at hand, so the drivers can't be bundled so they are normally acquired by a 3rd party repo. This repo basically pulls down an Nvidia driver release and makes the dkms / akmod packages for the distro. This is usually OK. However sometimes Nvidia drops headers from the release meaning older kernels can stop working and sometimes the kernel devs drop headers from the distro which causes the same problem. Now you can set it so that grub holds on to kernels longer which is what I did. But it's a PITA to keep having to load an older kernel until the packages sync up. It's just annoying.
This problem is capture here as well.
My complaint with Nvidia on Linux is more pragmatic. For example, Nvidia's proprietary drivers only like certain kernels, but I like to install Liquorix or Xanmod for better performance. Been using Liquorix because the input lag is noticeably better. I know there's a way to modify the drivers to work with certain kernels but it's a lot of work for something that should just work. The other problem is that a lot of fixes to games through Proton usually don't effect Nvidia immediately since Nvidia has to implement it into their drivers, and Nvidia is slower at this than MESA. Eventually Nvidia does get the fix, but I like to play my games now.
When the driver comes with the distro none of this happens. It's seamless and smooth. It's how things should be and its easier than Windows.