CHDK (Camera Hack Development Kit) lets you do amazing things. (I suggest you do a Google search for CHDK, it's amazing for Canon cameras!) This camera becomes a super camera with features to rival SLRs and more. The photo quality is excellent. Battery consumption is average with rechargeable batteries, with good 2500 mAh batteries. I bought a couple of these and mounted them side by side on a custom made stand and used CHDK to use their USB ports so both could take a picture at the same time for great 3D stereo photos. The flash works great, the photos are good, even in low light they are quite decent. Cons: Video recording is so-so as the video had a lot of encoding artifacts when objects are moving or the camera is moving a lot. (Real life example, I filmed my daughter riding a carousel and all the movement caused a lot of blocky artifacts.) Otherwise, if you're filming in a well-lit area with little movement, it's perfectly acceptable.
Canon PowerShot A480 camera, black
108 Review
Nikon COOLPIX L810 Digital Camera: 16.1MP, 26x Zoom, NIKKOR ED Glass Lens, 3-inch LCD (Blue)
95 Review
Revamped Sony Alpha a6000 Mirrorless Digital Camera: 24.3MP SLR Camera with 3.0-Inch LCD and Power Zoom Lens
103 Review
Nikon D3100 DSLR Camera Body (Kit Box) - No Lens Included, International Version with No Warranty
298 Review