I used to love Windows Live Video Editor, but they changed it and removed some of the features. I've used - and loved - Adobe Premier, but that's WAAAAY overkill unless you're doing multi-camera work. I recently picked up Magix's Movie Edit Pro, but haven't had an excuse to use it. My long time go-to for putting music, intro, and outro on a single clip is....PowerPoint. It turned out to be easy to work with, if you are used to using the animations and timings.