I wrote this on another forum when somebody posted up photos taken in auto mode. Auto mode is useful for getting 'guaranteed' shots, it is, however, not the best for the getting the best shots or the most creative shots. If you could use Auto mode to do that, there would be no reason to have all the additional settings on the camera.
I came from a Fuji S5700 to a Canon 450d and looked on in horror as I saw my brand new 450d blow out skies, where the S5700 would not. The fact of the matter is that the Fuji is better at coping with wider dynamic ranges.
Which is why the dSLR's have all these fancy menus. You have to know that underexposing a shot, or overexposing a shot; using aperture, shutter or manual priority modes; average or spot metering; using gradient or neutral density filters or no filter; will improve your photo. These kind of things.
It is in many respects much easier to get a 'pleasing' photo with a compact digital camera than it is with a dSLR, however get it right with a dSLR and you'll know it's right. It's much more rewarding and the photo will be of a much higher quality.
I guess in the future digital compacts and dSLRs will be one and the same, but that's for another thread.