The only time I’ve ever really had issues with Nvidia drivers is when installing the meta package for CUDA (because it tends to include a previous version of the driver, which causes install/uninstall havok), or with laptops and hybrid graphics.

But the laptop issue is almost completely gone with newer distros like Bazzite.