If you have the skill and the money to make all of your own fun and don't want to rely on a community for any of your entertainment, social interaction, or the upbringing of your children, then rural living is nice. Who doesn't love the outdoors and enough space that you can do what you want without bothering your neighbors?
If you enjoy participating in the things that are too big for a single household, like arts(including live music), nightlife, and cultural education, you're not going to find them in a small town. There might be the occasional event, but it's the rare exception that proves the rule.
Of course you can leave a city to go see the great outdoors and you can leave the country to go visit a museum, but one is definitely networked living while the other is insular and the difference in these atmospheres becomes very palpable when you've lived in both settings.
Small towns are also much more homogeneous population wise. The limited economic opportunity in rural places means outsiders don't usually move into the town and traveled or educated natives leave the town to go live somewhere they can make more money. That's not a value judgment on the people that remain, I'm just pointing out that small towns naturally funnel down to a less diverse population.
If you think well-traveled people who like to educate themselves are better company than your average homebody, you might get bored. If you think such people are uppity snobs and you want to rub elbows with more genuine folk, too bad because you're the outsider moving in and the genuine locals are going to think you're an uppity snob that needs ignoring anyway
