I would recommend that you let the motherboard do all the tweaking.
Most of the time, the motherboard do a good job in handling CPU fan speeds so that it would be silent when idle, and it would just crank up the fan speed when it deems needed.
This way, it would be most of the time fail safe as the fan is fast when needed to prevent overheating