The spec I'd say was perfectly reasonable (unless you want lots more bells and whistles). A selling point for the urbex community might be that it's built with an alloy body not just plastic - they are tough and will take a bit of bashing. Reasonably weather resistant too. Definitely at the professional end of the market despite being a crop sesnor. Possible advantage over Canon (not that they do an equivalent model really) is that pretty much any F-series lens will work with it. Battery life seems good
I have a D300 and also a D300S but now tend to use full frame more. They will still do the job if necessary.
One thing I'll add now is that any camera is only any good if you use it.
My youngest son loves the fact that my Nikons have much better viewfinders than the bottom/mid-range Canons BUT he finds that they aren't comfortable in his (small) hands so he's unlikley to to change. In my case I chose the D300 as it's a full size body and suited my chunky hands (so did the Canon 1D but I couldn't have afforded that at the time). Before making your mind up try the camera out (if the shop won't let you do that then go elsewhere for your camera purchases). Try holding it, using the controls, taking a few photos.
Happy to try and answer any specific questions
A couple of images taken with the D300s in both cases using an 18-200 DX lens