I get the impression that a key part of good photography basically comes down to trying to manipulate light so that the camera doesn't have to compensate; as shown in a youtube video of a professional shoot performed with an iphone 3GS
It also depends what kind of light you like. I don't really like flash very much and just use natural light for everything I shoot. I am lucky in that I have tall windows in my flat which makes for a nice soft directional light on overcast days and that works for me. This does mean I am limited a bit in what set-ups I can do but it's a look I like. A couple of examples of photos taken in just daylight in the flat:
(http://farm6.staticflickr.com/5013/5401346576_632013db02_b_d.jpg) (http://www.flickr.com/photos/mr_atrocity/5401346576/in/set-72157609995640417)
(http://farm8.staticflickr.com/7097/7278839092_a3e871eb7c_c_d.jpg) (http://www.flickr.com/photos/mr_atrocity/7278839092/in/photostream/)