It depends on what video you make
For desktop recording videos, it is recommended to use camtasia studio 6.0 or screen recording expert, which can record the desktop while narrating.
Movies or DV videos: It is recommended to use VideoStudio, Sony Vegas, EDIUS, PR and other video editing software for production. Special effects need to be produced using AE and MAYA. Sound can be produced using Adobe.Audition 3.0. Make.