At 800 pixels wide, almost anything will look good (or equally bad), on a big monitor or large print, this is where the P&S or coolpix shots will show their limitations. Prior to shooting with a D700, I had been shooting almost 5 years with a Coolpix 8800 which was much better than the half dozen of P&S I have tried. Event at 800 pixels, it is fairly easy to tell the Coolpix and D700 daylight shots apart, but boy are the differences obvious on my 30 inch monitor or in low-light shots.
Despite being a good shot, I find hartyfisher P5000 shot very coolpix in mood.
That being said, someone that do not care about photos or is not willing to invest any effort is probably going to be more successfull with a decent coolpix-like than with the best DSLR available on the market.
I have many friends that shoot their vacation with P&S and out of thousands of shots, they may have 10 good one by pure luck and none in low-light. To me, trying to get good shots out of a P&S is a total waste of time, talent and money.