Here's Skape 3D Map of Leicester England to give you an idea of what to expect:
Cities XL comes close to this but the level of detail shown in this video is much greater. Makes you wonder about the next gen city builder. Also, makes you wonder how AI would be integrated into the simulator. GTA IV (despite being controversial) does a good job of integrating AI with the environment as show below.