The compatibility issues with Nvidia proprietary drivers stem from
DKMS, Dynamic Kernel Module Support.
Essentially, the proprietary drivers are binaries that are compatible with a range of kernels, with a thin shim compiled for each kernel using DKMS.
These can be compiled beforehand and distributed as a specific kernel-package-version dependent packages, but not all Linux distributions have the manpower or volunteers to do so, and Nvidia definitely cannot afford to provide those for all Linux distributions. On most systems, that shim is compiled on the target machine itself, automatically per DKMS configuration.
So, the solution is to ensure you have kernel headers and working DKMS auto-configured
for all future kernels, before you install the Nvidia drivers. That way, as long as you have a Nvidia driver compatible with your kernel version –– not distribution patch version; just the kernel version suffices –– any kernel update will cause DKMS to recompile the shim for the Nvidia drivers.
This is not specific to Nvidia, either: VirtualBox additions (like the video driver allowing X/Wayland video resizing) use the exact same mechanism.
A secondary problem with Nvidia drivers is that it may depend on innards (but not kernel-userspace API/ABI) of the DRI layer, which means that a specific Nvidia proprietary driver is compatible with only a range of Linux kernel drivers. It is the DKMS that recognizes the incompatibility, too –– incompatibilities that result in runtime errors are rare, although glitches may occur on new kernel until Nvidia releases compatible drivers.
Thus, it is all about DKMS and its configuration, and monitoring it when updating/upgrading kernels; not so much about distributions per se.
Some distributions may have maintainers that do this for you (and all other Nvidia driver users), but it should not be a requirement.
(In case you have labeled me a Linux zealot, back in the AMD/ATI proprietary driver era, I compiled my own kernels and used the proprietary drivers for better 3D support on 680G/780G integrated-on-motherboard chipsets myself. It was much more work back then, too. DKMS was specifically designed to ease that work by
Dell!)
This is unfortunate, I do agree. I know the history, and it is a bit convoluted on both (Nvidia and Linux) sides. Yet, it is not a Linux distribution issue per se –– as in, "
X is compatible with Nvidia drivers,
Y is not". Some distros may do the DKMS config for you, but in the rest, you need to do it yourself. Fortunately, after it is set up correctly, it should keep working even across kernel updates, only requiring you to keep up with Nvidia driver releases afterwards.