Mental Ray is a very good renderer that has been used to render the CG in many movies (eg Panic Room, Fight Club etc). It has lots of great features for making your renders look extremely realistic.

It's been around for quite a long time as it's own product (and still is), but XSI and now Maya 5 have it integrated into them as a standard renderer.