Blender is a free 3D animation program that can be tweaked to do just about anything you need. This is definitely a good place to begin before buying the very expensive 3D Studio Max and Lightwave.

Blender Opening Crawl
J. Daniel Sawyer has sent in a tutorial for recreating the opening story crawl using Blender. He has included all the required meshes as well.