SimCity DS is ok for a handheld, but it doesn't compare to Simcity 3000 for the PC.
If you have a descent PC the latest city simulator is Cities XL, which has multiplayer, but has monthly fees like an MMO.
Edit: I forgot there is also SimCity Creator which is the followup to SimCity DS. Never...