Summary: Wow, those pictures are really cool. Have it for a few days now and mainly made different pictures in automatic setting. I bought the camera for it's awsome picture quality and so far it delivers. As others have said before, there are a few kinks you will have to live with, if you go for Nikon's entry level: 1) flimsy covers for battery/smartcard/lens 2) this thing eats up batteries, get lots of NiMH rechargables.
Summary: Nikon Coolpix 800 has two shortcomings: 1. The flash is terrible. Almost always, the flash shots come out with the subject bright in the center and the backround completely dark. It looks like a metering/exposure problem. 2. The camera is slow. I take a lot of pictures of moving objects, my kids etc. Almost all moving shots, the camera takes the picture a second or so later than the actual shot which means I missed the shot.