It is very difficult to say what is best as opinions will differ greatly.
I have been lucky enough to use the Adobe Premiere range from version 4 up to Premiere Pro 1.5. I have also been fortunate enough to use Vegas 5 and 6. Both the full versions of Premier and Sony Vegas are excellent but pricy. They also take a bit of getting your head round if you are not familiar with video editing.
I did try Pinnacle (full blown DVD version) and did not like it. It did work and it did produce a DVD at the end but I found it confusing. But to be fair, it was probably more down to what I was used to doing rather than the product.
next door neighbour wanted to get into video editing and DVD creation. Never used a computer before in his life. He bought a Dell 9100 and bought Adobe Premiere elements V1 on my recommendation. He is up and running with a little help. But Elements is very good. Quality is good. Menus are restrictive, but I believe V2 has sorted this. Dolby stereo sound too.
GO FOR ELEMENTS>