Depends on what kind of photography you want to do. My preference (and something I need to do more often) is street photography and I've heard a smaller camera -- even a smartphone -- is probably preferable to a DSLR.
Also, it really isn't the camera that makes the pic so gorgeous -- it's the photographer ;)