If you get the right Canon, you can load your own software onto it to give it special powers!
http://chdk.wikia.com/wiki/CHDK
Personally, I'd stay away from Sony. Loved my P200 before it broke, but indoor shots haven't been very good on the newer versions I've had since, one of which I returned because of the notorious Sony defective sensor.