I use Pinnacle Studio, and I've used it to make dozens of DVDs. It's a simple program, made for the casual consumer. Hence it's price, around $99. It's easy to capture video from your camcorder, edit your movie, add titles and music, create a menu, and burn a DVD.
I've used Premiere, mainly just playing around with it. Premiere is a professional solution. It can handle multiple video and audio tracks, advanced color correction and it can handle high-definition video. Premiere is a lot more complicated than a consumer video editor.
I'm eventually gonna step up to Premiere. I need the power of Premiere for some future projects.
Pinnacle Studio is great for home video stuff, but if you needed to make advanced video or documentarty filmmaking, Premiere is what you need.