SimCity Societies
Due out in November, (you can preorder it here), SimCity Societies promises to let you build cities anyway you want to. Taking a different approach to previous SImCity incarnations, it's less about planning
Games
Spore Cities
I love these screenshots from the forthcoming game Spore. The brainchild of Will Wright, who also designed Sim City, the cities in Spore have a great feel to them, like Will Alsop channeling