Check this out....

City Engine

It's all rules based 3d modeling that allows you to design complete 3d cities.  They can be exported into a variety of places, and the capabilities of it just blow me away.

God, I wish it didn't cost $4600 though.