Gamer’s Digest has a great writeup on the process of making the Intro Cinematic for the new Killzone2 game for the PS3.
Assets were processed and created in Modo, Z-brush and Maya, exported to Maya, where they were rigged and animated, then exported to Houdini which was used as the primary 3d application for all the final stages in the project including shading, lighting, rendering and visual effects. All layers where rendered using Mantra, Houdini’s own renderer before being composited in Digital Fusion.