I have a
Canon Powershot SD780IS
I love it! I use my DSLR a lot, but we definitely use this little guy a lot too. It shoots HD video, so we use it as our video camera as well!!
As far as how it does in low light - you'll need to use the flash. Mostly. But it does a great job! I've been VERY happy with it.
It's tiny and SUPER light!