SimCity 4 still brings my current laptop to its knees. If it wasn't for the inevitable graphics glitches (which may in fact be my video card overheating, who knows), I would still be playing it regularly.
Its probably because the game itself was designed for single-processor machines and was never adapted to SMP systems. The graphics glitches are likely because the game depended on certain features of older GPUs