I guess it is all cards whose fans are software-controlled. I have a 7600GT AGP and 8800GTS G92 whose fans are always 100%.
I now know I should have gotten the Radeon HD3870, its fan is hardware controlled - increases fan speed only
when the temperature is too high. Talk about Nvidia's Q&A