True, you must learn how to compose the pic but the lenses are more important than the camera.
Here's my son's Flickr page:
http://www.flickr.com/photos/dark_orange/
He uses Canon but most of what he does is without flash, even indoors. He has what he calls his "fast lens" which he opens wide and gets a narrow depth of field for effect.