I use Linux at home but as an IT technician have experience with Nvidia in the Windows world. And it was pretty terrible there too.
You have to create an Nvidia account just to get the latest driver (🤦♀️) and despite its supposed prowess Photoshop struggled. Solidworks (CAD Software) also had issues with Nvidia and would only work with specific driver versions.
Overall a real pain.
I would only recommend AMD especially on Linux as they say least provide open source drivers. Plus their CPU’s are actually very good. I’ve seen some ancient pcs running Windows 10 on AMD CPU’s.