Note that in SimCity 2013 you still can't really do this. A sim finds a new job every day and finds a new home at the end of the day. Really.
You may be right there's just no way to salvage the current SimCity 5 problems (if that's what you're implying), but I don't think the current issues ruin the game at all. For me the illusion mostly holds up and the pathfinding issues are mostly corner cases. So I don't think it's a fundamental problem with the game design and I think a few AI patches can make a world of difference.
(although, arguably, a macro-level simulation could have resulted in a much better SimCity because that would allow for more depth and larger city areas. And arguably a sim-level simulation is a bit of a gimmick that doesn't add enough to the game to justify the complexity and PR buzz, but that's a different issue)
If the only way you play is to build large, spread out suburbs full of low-density buildings then yeah, you can conceivably play the game without seeing the ill effects of the bad pathfinding.
But as soon as you even see your first high-density high-rise the whole thing starts to fall apart.
I don't think this is necessarily unfixable - but it does require a level of reimplementation that I don't think EA would be willing to make.
The real horror comes when you start a region's great work. A significant number of people will leave the city in the mornings to work at the great work. If you are making a great work you are probably sending dozens of trucks with resources to it as well. The end result is you get easily 10x more vehicles leaving/entering the city. The queue to get in through the single lane off-ramp from the highway then ends up stretching all the way to the next city, and it takes a good 24 hours for the cars at the end to get in. It then ends up stabilizing, taking maybe 4-6 hours for someone to get into the city.
Also, a large number of cars 'just passing through' will use your city entrance as a 'quick' way to do a U-turn on the highway, blocking traffic even more.
Though even SimCity 4 actually assigned each sim a specific home and workplace. Their travels/resources were calculated on the macro scale though.
In previous SimCity games simulation was performed on the macro scale - not on each citizen. Any micro-scale view was just a visualization of the macro simulation. This meant you couldn't follow a sim's car from home to work and back, but it also meant scalability and the freedom to have a proper simulation model rather than a grossly dumbed-down one.
Agent-based simulation is the correct implementation (i.e., closest to reality) technically, but only in a world where we have infinite CPU power. A macro-simulation like previous SimCity games would have meant far fewer corners cut and a much less buggy behavior that are the result of emergent negative agent-agent interactions.
To take your analogy - SimCity 3000 and SimCity 4 use billboards and textures for fake smoke. SimCity 5 tries to go all-in and simulate the hydrodynamics of each particle - but has to cut so many corners to run that it doesn't even look like smoke anymore.