The original SimCity was perfection - you could build no roads and nothing but rail! ;)

Cities Skylines with all the DLC and the right transportation mods gets pretty “realistic” in that you can build a transit paradise but the car still exists.