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.
Discontinued Canon EOS 7D Digital SLR π· Camera Body Only with 18 MP CMOS Sensor
88 Review
Nikon D5100 Digital SLR Camera with 18-55mm VR Lens - High Resolution 16.2MP
172 Review
Nikon COOLPIX L810 Digital Camera: 16.1MP, 26x Zoom, NIKKOR ED Glass Lens, 3-inch LCD (Blue)
95 Review
Canon EOS 60D: 18MP CMOS Digital SLR Camera Body - Your Next Photography Companion
125 Review