I am a total novice, but want to put together some cool movies for family. Looks like some good options may be: Sony Vegas Movie Studio 10 - HD Platinum or Corel VideoStudio Pro X4.
two main things I want to be able to do are add my own music tracks without any DRM BS and also to be able to do voice narration over video with music playing in background very low.
Any thoughts or input?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic