Humans were built to socialize and live in societies though. It's part of our own nature to group up and form communities.
Cities in the 50,000 to 250,000 population range are not doing that well. That's what drives population to mega-cities. This, when you think about it, is strange. A city in that size is big enough to support multiple factories, large retail establishments, fully equipped hospitals, entertainment businesses, repair services for all key technologies, and an airport. So why don't such cities outperform mega-cities, where the friction costs of scale start to get in the way?
This has been studied. Search for "medium sized cities" "problems". The phrase "urban shrinkage" is used in Europe. In most of the developed world, medium cities are not doing well. What seems to happen is that young people leave, the average age becomes older, a smaller fraction of people are in the workforce, factories close, and a slow death begins. Those forms of decline feed each other.
Japan is furthest along this path. Only Tokyo and Osaka grow; the rest of the country has hollowed out. It's a big issue in the US and in Germany. Don't know about other countries.
Without growth, medium sized cities age and die. Yet population is leveling off. Now what?
We can let the weirdos that want to live in huge cities make the anti-pneumonia medicine and use it elsewhere.
I get it, it can be alienating to live in modern society. But you can create meaning and community even today. Probably not if you spend 80 hours a week in the office, but if you put in the effort to get to know your neighbors, join local sports clubs and keep up with the friendships you've built over the years, having a social group is not out of reach. It's just that you can't maximize for two different goals at the same time.
No wonder we love minecraft and Satisfactory and playing murder-hobos in ttrpgs. I would be in favor of restructuring society to be in smaller units, communities where people know and understand eachother, but nobody has that power.
One thing I disagree with "We won’t live in small villages with cobbled streets en masse anymore because we need the giant glass skyscrapers and the congealed intellect of our multi billion population to move ahead"
Do we? What is "moving ahead"? I would say there's a good chance our way of life is simply going to waste all the resouces that sustains it and collapse over a long period of time without moving on to a "higher" state. I know lots of people working in tech, none of whom actually advance useful technology. Instead they advance technology that makes their bosses rich and makes people consume more for no real benefit. That's actually the opposite of useful. The glass skyscrapers are not helping us move ahead.