I use a Canon PowerShot S1 IS. I think this model has now been upgraded to another number.
It's an SLR, image stabilization, 3.2 Megapixels, and has about every adjustment on it you could want. The following images were all taken at 1/20 sec, f2.8, 35mm equivalent zoom of 40 - 125 mm (Mickey is the 125mm equivalent zoom), and a resolution of 1024x768 to 1600x1200 pixels. I purchased the camera in 2004 for less than $400.
It has 10X Optical Zoom and 32X digital zoom. It will also record sound and attach the sound file (.wav) to the photo. It will also shoot video but that is very dependent on memory and I think the resolution has to be pretty low. It has a nice photo-stitch capability, automatically senses camera orientation and automatically sets the photo for portrait or landscape. It has a popup flash with red-eye reduction, and depending on the speed of your media, can take about 5 photos/second if you want to catch stop action. Media is Compact Flash. It has an A/V output which will hook directly to a TV and a mode to display a slide show right from the camera.
If you don't have a tripod or something to lean against, you can still shoot at night making yourself a steady 'tripod'. Hold the camera tight against your face, put both elbows down tightly against your body, spread your legs slightly apart and stand rigid. Take a breath, let half of it out and hold it, then gently (very gently) click the shutter. All of these photos were taken hand-held, so it can be done. If you want a time-lapse (EG 2-second exposure) then you would definitely need a tripod, and if possible a cable release, or if that's not possible you might be able to use a self timer if the photo conditions merit it.
The camera's software saves all photo information including date/time as well as the shooting parameters. (That's how I knew the above numbers). These sample photos were all taken with an Auto setting, night mode, but no flash.
Anyway, this is my 3rd digital and I like it best. Hope this helps. If you have any specific questions feel free to PM.