Lived on a farm until I went to college, nearest town was 6 miles away with a population of 400. Being a kid it was pretty neat having all that open space to do whatever you wanted. Go drinking out in the field without having to worry about anyone catching you. That's about the end of the perks. Having to drive like 15 miles one-way for school or to any store was terrible. My $6 an hour part-time job went completely towards $3.25 per gallon gas.
Moved to town of 10,000 for college. Absolutely loved the small college town. Lots of stuff always going on, fun places to eat and drink at, ran into friendly faces on a daily basis, young population always present, shopping for just about everything I needed. Employment options were not good though. Worked a couple jobs there for 4 years after college and got paid way less than I could have elsewhere with very limited advancement opportunity.
Moved away to the Twin Cities 8 months ago. So many different places I can work at, big events always happening, any niche hobby I have can be satisfied regularly, got myself a part-time job at a brewery and it's the bomb. I hate how expensive everything is, though I do get paid significantly more. I sort of enjoy that I have not once seen someone I recognize in public. I live really close to work so traffic isn't a problem. Crime isn't an issue at all either. Overall it's an upgrade, though I find myself missing friends and family back home.
Farm life is the only time I wouldn't go back to. You have to be in a very specific situation to be happier there than you would be just about anywhere else. I could move back to a town of 10k but it would have to be for a great paying job.