Well , any render engine is pretty useless on game developing since you will be using the game engine. But if you do want to render professional images , Vray , Fryrender and many others are always good choices , and they are way more powerful than any original render engine ( being maya, blender etc..) and they require less experience to produce a good render. To render a good image on a stock renderer is way more complex than Vray or any other.
If you never worked on 3D , you may get 3Ds or Maya , try it out and then decide if you want to improve you're renders.
