My Dad uses Pinnacle Studio to pretty good effect, but you would have to check out the DVD output options it offers as he doesn't use that part of it. It's one of the best all round options I have seen.

I use Final Cut Express, a great option if you have a Mac. I also find iDVD takes most of the guess work out of burning good DVD's. If you don't have a Mac then Adobe Premiere is spot on, I have used it in the past, very advanced but the output is impressive, it's also much easier to pick up than Final Cut.

Hope this helps.

Cheers

Cris.