Scene modes are there to set some parameters for different scenes. They do not replace or come close to what a person can do if they knew the basics of photography and practiced some. Scene modes are there to tantalize a newbie DSLR owner into thinking they bought a DSLR and that they don't have to learn about photography. Unfortunately, many have learned that is not the case, especially with the "sports" mode.
The D5000 is a very capable DSLR and will give you enough ability to grow as a photographer in the future. If you don't want to learn about photography then you're going to wonder why your photos don't look like what other photographers' images look like. You can buy better equipment but that doesn't make you a better photographer.
Not many reviews have talked in detail about the 19 scene modes on the D5000.
Anyone have an opinion on the usefulness of the 19 scene modes on the D5000 and if that's worth the trade-off on other features the D90 offers?
This will be our first DSLR and the scene modes might help us the first year or two get used to things and not force us to learn on the fly so much. That to me sounds like a useful trade-off on the LCD size (D90 being much better) and the AF not in the body as it's not hard to find AF lenses. (yes a bit pricier)
Thanks for any feedback on value of scenes.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic