Blender is a 3D modeling program. It works by manipulating points, lines, and sides on a plane. The rotatable axis works very well; you can manipulate and view the models from every direction.

Now I've seen some pretty wicked CGI, but the stuff people make with Blender is crazy good. By "crazy good," I mean good. Like, good good.

Now tell me that isn't good.
Blender's homepage can be found at http://www.blender.org/. And it's free.