almost any 3d program can do animations, lights and rendering. 3D is quite a big and complex world though, and to get cool results you will need sometime to learn (however it depends on the complexity of the art of your game). If you want to model in sketchup, then it should be fairly easy to export it to 3d max, add some lights, textures, and render it. Animations are a bit more complex, and even more complex are 3d character animations. I use 3d max or maya, although lightwave, cinema4d, softimage and others will get the job done, just pick one you like and start finding out how to do things. Remember though, that for backgrounds you have to be able to export in 3ds. format and for characters you need de .x format which in 3d max is quite easy to export, don't know in the others.
