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.
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)