I do not use noise reduction software.

I would like to get some suggestions on what is the best out there, how effective is the CS5 noise reduction,
and does anyone use it routinely? or just on problem shots, and how does it affect overall quality if used and not needed.

Thanks