I have not been stationed at Detrick but have plenty of friends that have, I have visited there as well. I live in VA so the area is pretty similar.
its an okay area there are definitley better it all depends what you are looking for.
What is your MOS or your Husbands?
Yes there is a lot to do in the area and Detrick is a good location to visit neighboring states without having to drive for day.
The weather is bearable winters are cold but not miserably cold. Its such a beautiful area in the fall to.
Compared to the areas you mentioned I would defintley choose Detrick over those but Ft. Sam would be a close second.
But its a very famly friendly area and the housing on post is fairly new and the off post housing is as you said reasonable.