Huntsville - you have to include Madison County as well. It’s smaller on a city scale.
Sports are minor league - AA baseball, arena football, minor league hockey, minor league basketball. The University of Alabama (at Huntsville) plays ice hockey as the major sport. This was my first clue that Huntsville is really different from the rest of Alabama. Heck, they were in Division I when I first moved there in the mid-80’s. Lots of golf if so inclined - part of the Robert Trent Jones Golf Trail.
Shopping/Food/Entertainment - You have all the chain stores/restaurants. There is also a small assortment of local flavors - see “Valley Planet” on the web for night life/eating local. If you like southern cooking - they have all the bacon grease, BBQ , and briskets you can stuff down. Music like the Big Spring Jam is all over the map. Blues over in Muscle Shoals. Nashville is a couple hours north for country. Regular touring entertainment at the Von Braun Civic Center.
Education - Schools are excellent. Huntsville has second highest density of PHDs per capita after the area around Sandia Labs. Lots of corporate representation due to NASA and the Defense Department. Redstone Arsenal has the Aviation and Missile Command, Lab Command, Army Material Command (coming soon), Ballistic Missile Defense office, Logistics Command, and others in residence. Lots of rank, educated civilians/scientists, who demand good schools. There was a lot of concern (in St Louis) when the Aviation and Troop Command was being moved to Huntsville in the early 90’s. They heard the stories about Alabama schools and culture. Early arrivers sent back favorable impressions and the masses followed to generally positive conclusions.
Housing - Lots of space, cost of living is reasonable. Need more houses because a new command is moving to the Arsenal? Just plow down some additional cotton fields and forest out in Madison County. Large assortment of McMansions and a old town district as well. Income tax and sales tax but property tax is not bad. Traffic outstrips the ability to build roads fast enough - not any different than any other growing location.
Weather - Probably not as hot - more humid. You’ll see some snow flakes in winter but that’s about all. Tornadoes and hail are a concern. Weather channels are all over the coverage though.
Historical events. Spent more time in Northern hands during the Civil War. This section of Alabama considered seceding from the rest of the state in the build up to the war. Many of the old families/houses sported competing Union/Confederate flags flying during the war. Became the Rocket City after WWII with the influx of German scientists and Goddard’s group.
Huntsville is very progressive (especially compared to the rest of the state). Want to build a regional airport to take a load off Atlanta? Me, me, me - we have the land. Good local government - pro-growth. A supercollider? Nuclear Power? Moon base? Rest of the state just rolls their eyes!
Summary - probably similar but on a smaller scale. Depends on what’s important to you and family. No family - I’d pick Texas.