The 480 is the best card if you want proformance rather then less fan noise. I remember saying when i sold my 6950 to get the asus 480 that i though the 6950 was the better card. But that was before i overclocked my 480.
Because to be honest i didnt think it would overclock so much because i though it would get to hot
You need to flash a 6950 to 6970 and have 880mhz core to get gtx 480 proformance. But then once i flashed mine i could only get it to 930mhz no matter how much power i gave it. Yet my gtx 480 can go from 700mhz stock to 860mhz on stock volts and no real increase in temps or noise. Also if you dont wanna overclock it then you can under volt it to 1000mV which i did on mine and it will run cooler and quieter and use less power.
Also this may sound odd but my 480 has less temps on games like bad company 2 then my 6950 did.
Around 82c with 55% auto fan speed
The auto fan on my 6950 would let my 6950 hit 86 to 90c
Guess i got a good card sence it does overclock quite nice on stock volts. Fan is louder then my 6950 but not noticable sence i use headphones. But then again the 6950 fan can be loud to over 60% speed imo. At 100% it sounds like its gonna take off

But i would say for the price the card sells for on ocuk and the fact its a great overclocker makes it a great card.