I admit I haven't read all 5 pages of posts, but I think I have nearly the best of both worlds.
I lived in a Major Big City from the time I was 17 until just 5 years ago - that's 40+ years.
Loved it, had a large circle of friends and lots to do, most of it walking distance from home.
I didn't even get my drivers license until I was 39!
Public transportation was easy and someone else always had a car if I needed it.
But I commuted to the burbs, and then farther when I bought my horse in 1989. Made the 1h+ each way trip to ride 3 to 5 days a week.
DH began riding too and soon we had two horses and the trek to see them was just part of our Not City Life.
I toyed with the idea of moving closer to the horses, but he was a City Guy through & through and it never got off the ground.
Then he passed away and suddenly I was a widow still making the trip mostly by myself, occasionally with a friend I got to shareboard one of the horses.
Soooooo...
5 years ago I sold the house in the city and bought my 5ac farmette, built a barn and brought the horses home to live with me.
In those 5 years it has gotten a lot more built up here, but luckily my immediate area is still mostly small acreages with some large farming operations still keeping a lot of the development sprawl at bay...for now...
The BigBox stores are within an easy drive if I want them but I can see stars at night and my area is still pretty much Ag.
Now all I still miss is the ability to walk to a store but the tradeoffs are worth that sacrifice.
And my Big City is just a 45min drive - which I make about 2-3 times a month for a volunteer job I have there.
So I get my City Fix when I need it and now coming home feels like Home.
And, of course, now I have chickens - can't do that in a Big City