Temp controlled is better for noise.
You wont see any decrease in load temps at max speed unless your vid card doesnt get hot enough for the fan to not go to 100%. You will see a drop in temp at idle and just normal usage.
If noise is an issue, temp controlled, if heat is an issue, 100%. If it is on temp control, it will go to 100% if it needs it though.