For anyone interested in visual projects, here's a few programs which you might find useful. If you know of any more then please add them.
_____
Celtx
Pre-production suite for media projects. Write screenplays easily using automatic formatting. Dynamically database characters, props, locations, images, sound clips, etc. Import images into a storyboard. Production schedule calender for proper planning.
I love this fucker.
http://www.celtx.com/ (http://www.celtx.com/)
_____
Blender
Digital 3D image and animation. Has a game engine which can implement python scripts. Includes a non-linear video editor (probably the best you'll find for free).
http://www.blender.org/features-gallery/features/ (http://www.blender.org/features-gallery/features/)
_____
Icarus
Motion matching software which tracks points in your footage and works out how the camera moves around the scene. Can be used in conjunction with Blender to composite CGI into a video.
http://www.peerlessproductions.com/tuts/pages/Icarus.html (http://www.peerlessproductions.com/tuts/pages/Icarus.html)
_____
Voodoo
Another motion matching program.
http://www.digilab.uni-hannover.de/docs/manual.html (http://www.digilab.uni-hannover.de/docs/manual.html)