How do I effectively use the Camera's Night mode?

[DanielLoreti]

I've been tanking pretty good night pictures with the flash through regular auto mode, but when I switch to Night mode to mess around with I just can't get good pics. Always a ugly yellow tint. What's the benefit of using night instead of the flash?