I'll throw in my (dissenting) opinion --
If you align yourself "left of center" on the political spectrum, you're gonna have a bad time. The area in and around Bryan/College Station is very un-apologetically conservative. A&M is trying to change that perspective with woke culture shifts but has met resistance. Take this in to consideration before moving.
There's also a dearth of professional development and socializing for young professionals. If you're looking to build a network outside of Aggie sports, religion, bar hopping, or politics, BCS may be troublesome for you.
As previously mentioned, the job market could be a challenge if you're not in tech, medicine, or working for A&M.
If you and your partner are looking for "things to do" that aren't family oriented, you're going to have to travel out of town. Yes, Houston/San Antonio/Austin are not that far, as many have said, but the driving is going to get old very quickly, especially if you do it more than just one or two weekends a month.
----
Context: Moved to BCS to go to TAMU in fall '01, left in 2020 and couldn't be happier. I'm fairly conservative, so the town's political views didn't upset me. Was happy as a clam aside from the fact that there wasn't too big of a community for aspiring young professionals (outside of the bar / Aggie sports crowd). Not active in a church, so I didn't have that sense of community. Knew it was a great place to live if I was well established and had a family (which I didn't have when I left in 2020). Moved to Dallas right before the pandemic to pursue a job after being let go fall of 2018 (and to be closer to family when starting a family of our own).