Even today you find folk taking years of college classes to learn animation and how to create such things. Maybe there will be a "no lessons required" software for you someday. Maybe it is here now but you have to pay up?
Did you try the Apple video editing, creation software? Nice stuff, and for folk that don't want to invest their time to learn old Windows apps.
Bob
I need it to voice over videos and add special effects like explosions and gun fire.
i dont want the software to be too expensive or to complicated.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic