I have the DSC-W100. Great camera. The battery life is far more than I expected out of a digital camera. Does 640x480 video for as long as you have space on your card, with sound.
It has a high ISO rating, larger sensor size than most digicams, manual aperature (I think W100 only).
Cons: Proprietary Sony stuff, like Memory Stick Pro and their stupid USB/composite-in-one cable. Battery door is a little loose and can open sometimes by accident. Screen resolution is relatively low.
My other choice at the time would have been the Canon SD700 IS, only because it had image stabilization.