We moved back 8 years ago and never looked back. My wife, not an Aggie, and I lived here in the mid-90's and she swore she'd never come back. She likes the amenities of a big city. She's loved being back. Great restaurants (which weren't here then), great shopping (and then there's Amazon - not available then), and great schools (better than from where we came) add up to a solid decision.
Agreed on the CSISD being the class of the county. If you want to avoid the irrational insanity that is rezoning in CSISD, there's a new charter school that will be every bit as good, and the kids will come out fluent in Spanish and Mandarin Chinese. If you choose the charter school, it doesn't matter where you live.
One other piece of advice, if you're going to live outside either city, make sure it's where they are less likely to annex you. We currently live just outside College Station. So, we don't pay College Station city taxes. We already have trash service, water, electricity, a septic system and police protection (I see a sheriff's car in our neighborhood with regularity). If we get annexed, we'll be taxed but will receive no city services. Not a fan of annexation. There are not enough houses out where we live to entice the city to annex us, but one never knows. Texas considered a bill last year that would give homeowners the ability to vote on annexation, but it was defeated. I'm hoping it comes up again in this legislative session.