The Video Copilot site is arguably one of the best sites out there for learning Adobe After Effects – with their new Metropolitan and Skyscraper 3D pack (along with demo) it is also a must stop off for 3D urban modelling.
Their new Metropolitan pack features:
• Day and Night Textures Included
• Multiple 3D Formats (OBJ, C4D, FBX, 3DS Max, Vray)
Of course with a mix of Lumion/CityEngine you could do something similar and all with the free trials….