I've been here since summer 2010 and having had three jobs, one semester of grad school, two hospital trips, visits to many churches, and many new friends here, hopefully I can help comment.
To say Ft. Collins is like College Station in Colorado is accurate in that it is the more conservative, agricultural, veterinary university town in the state, as compared with Boulder. It has about 140,000 people and is close enough to Denver, just as CS is a smaller city and is close enough to Houston for when you need an international airport and a Pottery Barn. We are, still, in Colorado, however, which tips the scale in many different directions culturally. More tattoos, less littering, more active lifestyles, more bike lanes and walking paths, more high-brow beer, more pot, and more claim to a diverse culture (even though Ft. Collins is 80% white). My husband and I have found a niche here, with many friends and a church family, but it wasn't without effort on our part to ignore a lot of Texas-bashing that occurs, especially within the university.
The weather and economy are awesome in this town. It's sunny something like 350 days/year, and it almost never hits 100. And even when it's 90+, it's dry, and there aren't bugs! Jobs are great---we have large campuses for HP, Intel, and LSI, and then the university employs thousands obviously. There's also a large junior college in town. The housing market continues to rise and moves homes quickly; we bought a house last August that has already gained in value. Homes are definitely more expensive than what we were used to in Texas, though.
City services does a really good job, too. Everything is clean and landscaped all the time, and they shovel snow so quickly we don't even need all-wheel drive, just some sandbags in the back of the truck during the winter months.
The university itself is similar to A&M, but is smaller than A&M. Picture A&M/CS without West Campus and no development on the other side of Highway 6. There's a lot of great nightlife and social stuff happening downtown, all within walking distance of the university.
Hopefully this helps your transition!
Allison
Fightin' Texas Aggie Class of 2008