Final Comments
Despite some of my criticisms,
I actually think I like my D5000 a bit more than my D90. The critical decision point is whether you find the positionable LCD of use, I think, versus the handful of D90 features that the D5000 doesn't have. For me, only the autofocusing with non AF-S lenses, the 930k dot LCD, and commander mode of the internal flash on the D90 are things that might tip me towards the D90 over the D5000. The D5000, on the other hand, has slightly better JPEGs at high ISO values and that positionable LCD going for it.
Drawbacks
* LCD didn't read Kama Sutra. You can't position the LCD as well as you should be able to.
* Not for those with a closet full of older AF lenses. If you've got mostly older AF lenses and are just now getting round to going digital, the D5000 isn't the camera you want, as you'll be resorting to manual focus.
Positives
* Just about Right. Goldilocks approved: not too small, not too big, not too light, not too heavy.
* Most of what you need. While it would have been nice to have a DOF Preview button and bracketing, most everything else you're likely to want is there, including spot metering and sensor cleaning.
* Excellent Image Quality. State of the 12mp art. Enough said.