Well, I've lived here on and off for most of my life, and I agree with twinsmama - there really is not much in the way of culture, trends, and "scenes" that are easier to access in other parts of the country, so be prepared for that. (Some people who like it here disagree, but this is just my own opinion). The nicest areas are in Madison and south Huntsville. That's where most of the engineers and people in related fields (the Arsenal, etc.) live. North Huntsville is a very low-income area that is visually unappealing to some people, although it's not quite as bad as it used to be. Once you get outside of Huntsville, you're pretty much in "Deliverance" land, although again, I suppose that's not as bad as it used to be, either. Most of the people who really like it here seem to be those in government/engineering jobs (as they tend to have VERY good job security here) and those with strong Protestant backgrounds (there's a reason why they call it the Bible belt
The Arsenal-types jobs are pretty much the lifeblood of the town. However, they're actually having a hard time replacing a lot of the older engineers and analysts who are gradually retiring right now. So in order to attract more "young professionals", the city is trying to improve its image a bit. They recently built the Bridge Street Mall, which is nice at first, but gets kind of old after awhile. They've been talking about "revitalizing" the downtown area for years now, but I'm still not sure what exactly that's going to entail.
btw, I've lived in Nashville, too, and find it to be much more interesting than here.
Hope this helps!