The issues with Nvidia GPU's has been blown up way to much in the last few years in my opinion.

The potential problems you "might" face are:

• Not backing up your system before updating
• Using too old or too new a kernel version (Older versions may break or cause issue with newer drivers and bleeding edge kernels may introduce issues that weren't caught during QA) * Always have a LTS kernel installed as well as a newer supported kernel
• Using brand new hardware too soon (aka don't expect a newly released card to work perfectly day one)
• Trying to use GPU's in edge case uses or pushing the envelope without knowing what you are doing
• Not backing up your system
• Trying to use the wrong kind of card for your needs (A Quadro card isn't going to work well as a RTX card)
• Not updating your system (Nvidia drivers get regular updates)

For most major distros now a days you either select the Nvidia option when installing (like Manjaro) or install the drivers afterwards (Ubuntu based) and be off to the races.

Set up and use Timeshift, make a backup before installing updates and you can roll back if there is an issue.