What is a good freeware program that will allow me to add cool fx to a video?

Unfortunately such a thing doesn't exist. Video FX software is very expensive. I'd recommend getting the trial of Adobe After Effects though. You can download it from www.adobe.com