Night photography can look very awesome if it turns out right. But for it to turn out right, you either need a tripod or a very stable place to set your camera. Night time exposures are typically measured in seconds rather than fractions of seconds. Because of this, every bit of motion in your camera will be captured and this is why some night shots tend to look blurry.
However, there are times when you can use this to your advantage and get some really neat effects.
I guess that's one thing I like about using a digital camera. I can try stuff like this. If it doesn't work, I'm only out some electrons. If it does work, I have some nice abstracts.