When I was a child, I was spending my summers at my grandparents. They had a cozy house in the village. They worked the land, they had a few animals. They grew their food. They sold some wine and fruit at the market. They had a big house, land, clean air, clean water and they were healthy. They celebrated the holidays, had many friends, went to church, weddings, funerals, etc. Villagers always greeted them and stoppe…
Your problem is that you were happy as a child and unhappy as an adult. That's a personal problem, and has little to do with rural or urban living. As other commenters have pointed out, you can most likely afford to buy a farm if you really want that lifestyle. I suspect you don't, because it sucks major ass to have to do manual labor all day, to eat almost entirely the same things and see the same people for decades…
Revealed preference wins all the time.
See also the massive rural to urban migration in literally every country since 18th century Britain to present day Asia.