Generally you can get awesome results in your 3D renderer with out Pixel Shaders etc. Because that's all relatively new graphics card technology and as you should know there have been awesome 3D renders since the days of the Amiga when Cinema 4D, Lightwave and a few other apps were released for the first time. As indi pointed out, Mental ray is a great renderer, it comes standard with 3DS Max, Maya and Softimage|XSI (Softimage being the cheapest option) you can also buy Pixar's Renderman for those 3 applications as well, you can also get vray for those three and TrueSpace 7, you don't need a still render and a 2D application to get a good render result, although people do touch up their work in Photoshop for a better result, but look at some of the renderers you can play with and the renderers that comes with 3D applications, you can do a lot.
"Listen to Jah Music..." - Bob Marley