I've long agoused Pinnacle, and a little Wax (free), Windows Movie Maker (has evolved a lot), and Premiere as part of the CS4 and CS5 Production Premium suite (at work).

 

AFter Effects too.

 

There's Adobe Premiere Elements.

 

The one I like is PD, not Project Dogwaffle mind you, but PD as in Power Director, from Cyberlink. www.thebest3d.com/cyberlink is sort of a fan page of mine.

Pretty much all my videos in the pdhowler channel on youtube are made with Power Director Ultra. TRhe basic version is around $59 I think. Ultra around $99.

If you want to look at some sample videos I created with it try www.youtube.com/pdhowler

Vegas is, I think, also pretty darn good. And there's of courseFCP Fincal Cut Pro (or the non pro) on MacOS. From Apple.

 

Are you on Windows or Mac?  Wax is Windows only.

 

What sort of needs do you have in your solution, budget, numbver of layers, 3D layers? etc...