This is only the first part of the final pullout shot of a near future Paris being obliterated by a kinetic strike. Notice that the Eiffel tower is not there... It was the only 3D element in the shot. everything else is matte painting and camera projection.
I did this painting of near future Paris over about 3 days.

This complete shot was done entirely in Photoshop with the help of XSI for 3D support and projections. The turnover for this shot was very quick and was a collaborative effort from the whole matte dept. (Andrzej Tutaj did the cloud layers and Sophie Codaire did the final planet establishing)

You can see the animated trailer here:
http://www.gametrailers.com/player.php?id=19905&type=mov&pl=game