Nikon D5000 is a 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.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).
The D5000 has a number of other advantages over the D50. The first is a time saver for me. Its auto distortion controll seems to handle lens distortion "in camera" when the pictures are taken. Having the camera address lens distortion saves me from having to fix it after the photos are taken.