Re: What software is used to make this....?
Yes, the compositing of that image would have been done in Photoshop.
As for the gargoyles, they wouldn't have been made in a 2D package like that.
They would have been made by ATI within a 3D package like 3D Studio MAX or Maya, and then rendered out as images.
Abit IP35 Pro / Q6600 G0 / Zalman 9700 / 8800GTS 640mb / 4x 2GB Corsair XMS / X-FI Xtreme M / 1x 1TB / Antec 900 / Logitech Z-5500 / Samsung 20inch