So yes, it's a major step forward in terms of it being possible at all, but it's something you have to be pretty intentional about— and maybe that's reflective of the real world too. But it's always nice when media (games, books, movies, whatever) inspires us to dream bigger than we might otherwise have done.
USA style zoning is just stupid and is a major culprit of cities needing cars.
As far as I know there is no major city simulator that simulates non-zoned cities that are full of organic growth instead of the player, like a US mayor, deciding where people are allowed and not allowed to live and work.
It does have trains, but they are fairly limited use right now and it's pretty car focused.
I'm trying to just do one super long road in my current game.
I am talking more about a potential game where cities would grow like in real life, with people moving in voluntarily, and building stuff voluntarily, and the government focused more on building infrastructure. As far as I know there are no major game like that.
Closest to it in a sense is a space game (Distant Worlds, where you build the military ships and colonize planets, but the population builds commercial stations and mining operations, and the population have their own civilian ships for immigration and tourism)
I like to create areas that have no cars in my cities. Add lots of pedestrian and cycling paths, lots of trains, metro, ferries, etc and just watch oodles of people using public transport or cycling everywhere.
It's such a satisfying game.
I recall them being quite tricky and including political/social aspects (you need to appease your people to be re-elected etc), but since I haven't played them in years that stuff might not be as deep as I remember.
Do have a look though and see if it'll suit you!
But that structure also meant that I struggled to feel as much long-term ownership over what I was creating. It felt like I could get away with cutting certain corners that I shouldn't have if the game forced me to sit just a little bit longer with the consequences of my actions. Maybe that's just a sign that I was playing it right, but I felt like I would have had a better time if I'd been just a little bit more accountable.
You may be interested in CityState II: