SimCity 4 added significantly more complex transportation simulations (particularly in the expansion) - but was more or less handicapped for performance reasons (pathfinding only allowed movement towards the destination... conveniently ignoring the subway stop right behind the Sim).
Popular (almost de facto standard for SimCity fans) mods have sprung up to correct this, and with modern hardware there is really no performance hit.
Transportation is now, IMHO, the toughest part of the simulation - even fixing their pathfinding, it's still wildly unpredictable what your sims will do, and creating a mega-city generates a lot of congestion that so far I've been unable to avoid.
Popular (almost de facto standard for SimCity fans) mods have sprung up to correct this, and with modern hardware there is really no performance hit.
Transportation is now, IMHO, the toughest part of the simulation - even fixing their pathfinding, it's still wildly unpredictable what your sims will do, and creating a mega-city generates a lot of congestion that so far I've been unable to avoid.