I wanna make cities but I want to make cities without cars and Cities Skylines loves cars
There's plenty, but it all depends on what you mean by "good". Games in the city-building genre tend to focus on one area from which most of the challenge and depth comes from.
In Cities Skylines this is obviously transportation, growing a decent city is basically trivial, getting all your cims around without massive congestion is not. Tropico on the other hand has much deeper interactions with political systems and international relations, while in Cities Skylines your role as mayor is omnipotent and you can never be removed from office no matter how bad conditions are; in Tropico providing inadequate housing or food can result in your citizens rising up. Citizens don't even use cars by default and it's very easy to make very walk-able cities with great public transport.
The focus of Worker's and Resources: Soviet Republic is found in it's title. Your job as leader of a burgeoning Soviet Republic is to extract resources and establish industry. To this end, the main goal of your urban design will be creating cities that are able to provide workers for industry in the most effective manner possible. Thankfully, personal automobiles are not required for this, and if you want to create a socialist utopia of trains you're more than able to.
Open TTD and Transport Fever focus exclusively on mass transit and freight delivery, though primarily on the intercity scale. There's also plenty of City Builders with ancient or pre-industrial setting (Ostriv, ANNO, Builders of Egypt), these obviously don't have cars and are particularly fun if you have an interest in their historical setting.
To add to your last paragraph, there's also a few near-future/Sci-fi settings for City builders that have no use for cars like Aven Colony, which has pressurized walkways as the "roads" connecting your buildings.
Also Industries of Titan, though it's still very early access. Very dystopian space capitalism where you have citizens and workers (workers are citizens augmented with cyberware to never sleep and always work). You have to balance trash, pollution, power, and defenses all while trying to extract as much profit from your citizens and the ruins of the old colony that surround you.
Made by the Crypt of the Necro Dancer people.
Like others have said, workers and resources-soviet republic is where it's at. All of my cities in it are filled with all the cool urbanism stuff we all wish for
Cities: Skylines is a traffic simulator. Fun game but traffic is such a concern that I have to build every city around managing it -- it's the #1 concern by leaps and bounds. I don't know any other urban design games, maybe Workers and Resources: Soviet Republic?
One of the expansions fixes traffic by allowing you to do exclusively trolleys and ban cars.
Cities Skylines is still leaps and bounds over SimCity because it recognized that cyclists exist.
Soviet Republic: Workers & Resources is really dope (and is much less car-centric)
it's getting a major update soon too that's going to bring tons of quality of life improvements, underground infrastructure, better interface and snapping, etc just in case it looks too janky right now
The only other city building game that I've played recently is Cities XL. And by recently I mean 5+ years ago lol. But tbh I'm not sure there is a city building game that doesn't have a car bias.
The car thing is just a symptom of the deeply seeded disease of the city management game black box (Urban Dynamics). It's also easier to simulate if you are doing districting because each building is connected to a road and can spawn vehicles that go directly from A to B and back instead of hooking into a rail hub.
Even when they do rail, you still need cars to transport everything to the trains because that's just how the games work (buildings spawn cars).
