I'm surprised that the superb listing of free/open source software above (Cinelerra/VirtualDub/etc) missed one very obvious 'already being used' piece of software - Blender. Yes, it's a 3D modeling and animation app - it also includes a non-linear video editor, very useful for doing 'higher end' things like expensive pay software.
http://blender.org for more.