Camera Settings Question...Anybody Help?

[Super]

Can any of our Camera settings experts or anyone help with a Camera question? Because I don't know much about using different camera settings I normally just use an 'Auto' mode on my cameras. Normally when I try to adjust settings I go too far and actually have to revert the camera back to the factory settings because I make things worse. The trouble with this is that I can't do very good (in my opinion) night time stills and video because the cameras automatically adjust the darkness into a lighter result. What or how do I use a setting that lets me get night time shots showing the lights on a Layout without brightening too much on the results?