Creative Suite 3 Production Premium contains a whole host of programs and it sounds like you just need a good video editor. Either Adobe Premiere Elements 4 might do what you are looking for or if you have the money to spend then Adobe Premiere Pro 2 or CS3 would do. Other editors are available including Sony Vegas and Pinnacle Studio, it really depends on what you are looking to do and how much money you want to spend.

__________________
Better than a poke in the eye with a pointy stick any day...