UPS dropped off my EVGA GTX 470 today, it's replacing my BFG GTX 260 OC.
Not much to say really, installation was a breeze.
As for the heat and noise issue, I'm completely happy with how it worked out.
I set up a profile with the fan at 75%, which is the point it becomes noticeable, and ran Kombustor until the temp leveled out, which was at 75C. This was at stock clocks.
I had considered going red with a 5870 after reading the reviews but I'm glad I stuck with Nvidia, I simply like the feature set available as far as AA modes, etc.