I deliberately put my govenor to the conservative one, as I hated fans spinning up for a second and then down again repeatedly. Much rather sacrifice a bit of battery and speed for quiet.
I wanted the full power when doing long compiles and such. Just not the fan jojo acion when neowsing the web or writing.
Also swapping the governor was trivial and reliable. Modifying fan profiles has always been a bit of a struggle for me, with huge differences in hardware support, persistence etc.
It's just bad fan curve for given workload. Sharp rises and drops are annoying to hear, curve that does that + race-to-sleep do not work together. Low speeds do cause throttling.