No - I very occasionally use the noise reduction filter in CS2. I know people say its not as good as NeatImage etc, but on the other hand if time is spend learning how to use it effectively it seems to work very well.
Best thing is to avoid noise in the first place by getting exposure right (or slightly over exposing).
I found my D200 noisy at first. Then after a while I realised I simply wasn't getting exposure right.
I found that my camera habitually underexposed by between a third and half a stop. Even when the histogram was indicating whites off the end of the scale, subsequent readings with the eyedropper in PS gave readings of about RGB 248.
I found that this half a stop or so make a big difference to noise, artifacts, saturation etc etc.
Nowadays I rarely use noise reduction. Perhaps once in every hundred pictures, and then only for blues, reds and shadows.