I have had good luck with Ulead Video software that came with my DVD Burner. It allows me to capture over firewires and edit video and make transitions and render the video for burning on DVD and other media

If you want really high end and lots of learning I recomend Adobe Premier.
-: phenious :-