I got a S90 when it first came out, and upgraded to the S95 last year.
Believe all that you have read. While we all know its silly to think it can be better than a DSLR, IME it can take over as a always with you, day to day camera.
I used to take my 40D everywhere but did find i wouldn't always use it. I had compacts but always prefered to have something i could control in the way that i wanted, and get results as close to my 40D as possible.
I still use my S95 more than my new 60D during the week. Of course if im going anywhere special ill take the DSLR but for general walkabouts where i "might" see something interesting the S95 is the camera of choice.
I also find it fun to use. Maybe its the fact that i like using the LCD to frame the shots but ive been taking more arty looking shots with this than i have, or would, with my DSLR.
Well thats my experience anyway. Its still a compact and has limitations but its the first compact ive had that i dont feel restricted to shoot as base ISO.
Ive got a gallery of my S90 and S95 images here on flickr if its any help.
http://www.flickr.com/photos/davebass5/sets/72157622647970370/
http://www.flickr.com/photos/davebass5/sets/72157624984928137/