Even though you already mentioned it I thought I would still throw out there a recommendation for pinnacle. I've tried alot of different packages and pinnacle is by far the simplest to use and has the best interface. The only complaint I have is the lack of advanced dvd menus. You can make menus with a link to each chapter, but you can't link one menu to another. This is something most home users won't notice but I do video editing/authoring often. I'm hoping they will add this feature in the future, it might already be in version 10, I"m using version 9.
Ulead Video Studio works well also, but I just don't like the interface...