I use Cyberlink Power Director 10. You can put in sub titles, voice over, everything you need for a good vid. It's a bit difficult at first, especially adding music I found, the editing part, took my partner and me a while to figure that out, but once you get the hang of it, it's really good. Also has some good built in special effects, or you can create your own. Not all that expensive either.
Also have their wave editor, for just music, haven't played around with that a lot as yet.