I spent last summer with a D5100 paired with two lenses; 18-200mm VRII & 70-300mm VR. I also have a S95 that goes everywhere I go. It worked well for me in the environment that I used it for.
I personally wasn't as enthralled with its articulating screen as I thought I would be. I got too much refection from it to help me much You have to shoot Live View & Aperture Mode to shoot video. I shot a lot of video in the blind due to the reflection. There is nothing like a 5 minute video of grass. I did get some good videos when there wasn't too much reflection.
Because of the video restrictions, I shot my stills in Aperture Mode as well with the Fn button set to ISO. Missed some of the displays and controls of other Nikon DSLRs. Also, it won't auto focus manual lenses.
I now have the D7000 as well.
Someone talked about their S100 which I have read a ton of bad reviews. Just wondered if they were thinking about the S110? Yes, I know it's from the darkside.