Autofan script works well for AMD GPUs. But I have some troubles with NVIDIA GPUs. Which option do you use ? Autofan or static fan speed for your NVIDIA rigs.
Autofan for Nvidia works also very well if you use proper OC.
If your overclocking is configured in such a way that everything falls from you from any sneeze, then of course static control is better.
The version of the drivers also matters. If you have a driver less than 418 series, you need to update them.