I'm a huge fan of the Canon S90 (and now the newer S95).
Here's why:
1. it is a very good "auto" camera. If you are not a photographer or hobbyist looking to shoot in advanced modes, the camera takes very nice photos in auto mode.
2. low light photography is fantastic because of the lense. Tired of those indoor photos or family photos that look "blasted" by the camera's flash? The S90 (or S95) has a better (brighter) lense than most point and shoots
(f 2.0), this lense opens up bigger than most p&s cameras and therefore allows more light in and results in better low light photography.
3. Manual shooting. If you want to start learning more about photography (or if you already know), the S90 is fantastic in Av, Tv, and M shooting modes. It's a fun, easy camera to change the settings on with the lense dial... you don't get lost in on-screen menus every time you want to set the camera for a particular shot.
I mention the S95 because it is the newer model and one of the improvements is that it shoots HD video.
I will say that the Panasonix Lumix comes up a lot in the Point and shoot discussions so you may want to check that out too.
good luck!