Noise reduction software is a tool that can save shot's you would have thrown away. It's not always possible to get enough light or the correct exposure.
I've found Noise Ninja the easiest and best to use.
Its not only the noise reduction that works noise ninja can also be used to sharpen your shots.
Just my 5cents - Ronny