What Mantis said.
If you've used a film SLR before and don't mind the lens changing, the equipment bag, and expectations from officialdom that you're a 'professional' photographer then it's well worth getting. It's all going to be down to what you're wanting to use it for and where, and how much creative control you want over images and so on.
I had a Canon EOS500N (film) with a few lens from 1997, then decided to go digital in 2003 and swapped to an Olympus 350UZ (on Mantis' recommendation), then in 2005 a Fuji 9500 - both of these are 'bridge' cameras, so with better optics than a standard compact, and bulkier, but with no lens changing (which is both a 'pro' and a 'con' depending). I got the Canon EOS450D last year, as DSLRs were then down to an affordable price.
If I'm going somewhere that I don't want too much hassle of lens changing or the 'professional photographer' thing, then I just put on the 35mm f2.8 prime and the camera is then pocketable (just!).
One other useful thing is that old film camera lenses with the same mount can be used on a digital camera - so my Canon EF lenses from 1997 also fit and work on their digital cameras which all have the same EF mount, similar I think with Nikon. You'll need to have had a fairly decent lens in the first place though, as the high resolution images magnify any optic imperfections. It also means however that you can also consider (very) second-hand lenses - anything in the last 20 years from Canon. You'll need to magnify the 35mm focal length by 1.6x to get the equivalent digital focal length though, because of the smaller image sensor on the 450/500/40/50 ranges - only the top pro 1D/5D have 35mm size sensors.
I'm only an average amateur, but if you want to see some of the pics I've taken with my 450D check out the following link - these pics have been processed, resized and cropped, and quality reduced for the web, but it will give you an idea of what the camera can do: http://pixec.fotopic.net/c1740129.html
PS: To give you an idea of the 55-250 lens quality, the mountains in this picture are twelve miles from where I took the picture and it's only been slightly cropped:
http://newimages.fotopic.net/?iid=yzusjo&a...&quality=70
And this picture was taken from around 4 miles away, again only slightly cropped:
http://newimages.fotopic.net/?iid=yzusjp&a...&quality=70
And this intrusion on a private moment was taken on a Swiss munro!
http://newimages.fotopic.net/?iid=yzusjr&a...&quality=70