Nikon D5000 12.3 MP DX Digital SLR Camera with 18-55mm f/3.5-5.6G VR Lens and 2.7-inch Vari-angle LCD

Great Camera. If you are new to the DSLR game (like myself) or you are upgrading and you can fork up the cash, it is definitely worth it. It has a very concise, simple, and easy to use interface, the buttons are very well placed, and the swivel LCD is very nice and useful in certain situations (I really like how it folds inwards to protect the screen). My main purpose for this camera is still photos so the video is a cool bonus and is surprisingly better than I thought (though if you are looking to do serious HD video, I'd go for an HD camcorder or something else instead). 

Nikon D5000 12.3 MP DX Digital SLR Camera with 18-55mm f/3.5-5.6G VR Lens and 2.7-inch Vari-angle LCD

The D5000 is essentially a D90 squeezed into a smaller lighter body (of course it lacks the internal AF motor, doesn't have as good a grip, and has a slightly smaller pentamirror viewfinder instead of the pentaprism in the D90 - all of this amongst a few other things, but hey it's cheaper for a reason - also it is mentionable that the D5000 has an additional live view mode, a few more in camera editing tools, and more scene modes compared to the D90 - all useful for someone new to the DSLR in the sense that you can learn from them or just use them to make your life easier and your photos look great).