I like the game a lot. But to be fair: you must download a good traffic control mod to setup traffic lights and road settings to keep the traffic under control.
Old Pharaoh style city builders certainly have a good deal more challenge when it comes to survival, but they're quite discrete and once you have a few templates for housing and industry nailed down I don't think they have much more difficulty to offer either.
I'd suggest looking at SimCity 4 for the peak of the in-depth city simulator. The systems in it go way deeper, it isn't limited by inevitable scaling problems with agent simulations (Tropico, even C:S), and there's a large, long-running modding community for it.
There's a few mods that would be considered basically essential, namely the Network Addon Mod (which overhauls the traffic simulator, in addition to a vast amount of content).