A rather corny question, is it any good then? Is it enjoyable or just boring with all the death and destroyed areas?
Why would that be a corny question?
Well.. I must say that, as a long time Fallout-fan and http://www.nma-fallout.com/-hang around, that Bethesda are really good at making rubble and destroyed buildings. There's junk items everywhere.
Vanilla FO3 did get a bit boring and depressing for me the first time I played it, because you spend so much time crawling through junk in destroyed buildings and metro stations. Occasionally you crept through junk in some abandoned vault. Doesn't help that the sky is covered in grey clouds and that there's a grayish green tint everywhere. Thankfully there's a whole set of mods that cleans up The Capital Wasteland and adds greener vegetation & trees, which makes the game feel less depressive. The game is set 200 years after the war so the wasteland should have been reclaimed by some kind of forest, although the radiation and inhabitants would still be as dangerous. I used the mod GreenWorld or something like that but that was years ago so perhaps there are better mods now. There's also a mod called Fellout that clears up the weather.
The DLCs also offer quite a bit of diversity in the environments over the base game.
At higher levels everyone gets ridiculously amounts of health; even unmutated humans shrug of several rifle head shots without being moderately injured.
Thankfully there are mods that remedy that as well.