Andrew Averkin has a walkthrough of a fantastic steampunk-style rendering of a mechanical spider.  The image was modeled with 3D Studio Max, tweaked a bit with Photoshop and using FumeFX for the smoke.

Making of the Spider – CGArena.