Frequently asked questions...Answered Here.
I use a Sony Handycam along with an ATI video capture card. I capture one frame at a time as a JPG. I use Adobe Premiere to edit. As far as special fx, well they are like magic tricks, something you have to figure out on your own.