As my user name suggests, we've moved around a fair bit. And my honest experience is there is no perfect place to live,. There is always compromise.
I grew up in London Suburbs. The transport was brilliant, there was a lot to do etc. It was during the IRA era, so there was fear, but people seemed to go out of their way not to let it impact on them. But, and I didn't realise until I moved away, was the lack of oxygen. I had a constant cough for years- tested for asthma but it wasn't that.
Moved at 18 to a Yorkshire city for University (actually turned down Imperial College as I couldn't afford to live there as a student, and didn't want the commute). Loved being able to walk everywhere. Did a year at Nottingham as well. Both struck me as a good balance for children/teenagers.
Then we moved to a small town in Germany. Pleasant enough, but not much for children- but it did have a lovely open air pool.
Then a tiny village in Yorkshire. Picturesque. Stuck without a car, three buses a day Monday- Saturday.
Bigger Yorkshire village. Not bad with young children, a few playgroups , leisure centre etc. Reasonable bus service for teenagers into a bigger town.
Lovely Mediterranean village. It was idyllic for primary age children. Great community. Half hour to beach. Own pool in garden. But for teenagers- they grew up naive. They had no real world experience. Year groups of 30 in a Secondary school do not work. Also it became claustrophobic after a while. The kids did their Rainbows with exactly the same kids as School, which were also in their swim class, and the Youth club, and the dance lessons...
German town/small city. Nice enough, but I didn't like it that much
Now.. Lincolnshire, just outside a big town. Its great. Massive range of activities for the kids. Walkable into town in 30 mins for an adult (hill makes it a struggle for small children, and not suitable for bikes/scooters for children). Cinema, shops, swimming pool, cafes etc. 45 minutes to nearest city. Only downside bis having to drive the kids 2 miles to school as we couldn't get a place closer.