I've used nightshot on my regular 8mm video camera. Although you can get some better focus because it deals better with the lighting you lose the color. I don't know if all cameras are like that but mine is.
I did use it more when taping at a wedding reception. It was pretty dark and it was a good way to get some pictures that the lighting wouldn't allow otherwise.