Having lived in city, suburb, and now country, I think matchewed is right on about values. For a long time, we dreamed of living on acreage, somewhere we could hike around and ideally not see other humans from our doorstep. The farther we went from our then-home city, the less expensive the land prices, and we were able to buy 80 acres for just over $1000/ acre. We fell in love with the land and didn't really pay that much attention to the closest towns, other than the distance to the grocery store and home depot. We came out to the property every other weekend most of the year for about 4 years, so we got to know the area a little better, but not that much in depth since we were just part-timers.
When I landed a job here, we switched gears dramatically from the city to the country. Luckily, it turns out we really like our little town, and have found some good people to hang out with. Best advice we got was to learn to cook every ethnic food we like that isn't Mexican, because there aren't any other options!
If we had tried to do this in our twenties or even early thirties, I don't know that we would have transitioned so well-my husband in particular, since he was more into going out to shows and events with friends (I am a bit more of a homebody). Now, our entertainment/stimulation options are movie theater, live shows every now and then, talks at the local community college, and some summer festivals/parades and that sort of thing, and that suits us pretty well. Most of the time we like to just hang out up on the hill in the middle of the woods, though!
TL;DR: low housing prices aren't enough if you aren't anchored by other things that you like about the lcol place you find.