Drop everything you heard...this is tech forums we aint noobs when it comes to hardware and cooling.
First answer me this...do you want a better card?? can you afford it??
In my opinion its not worth it to upgrade my card at the current moment, sure GPUs are cheap now adays but the performance jump isn't worth it from a 8800 gtx to a say gtx 260 or a HD 4750 ( less then 50% performance jump ). Currently I plan to wait at least another year or something along the lines of that for another generation of GPUs to come out or the prices to lower on the existing GPUs.