In reply to Swirly:
Go with Pinnacle Studio first, either as a demo or cheap version just to try it out and learn. Sometimes you can get it free with a box of CD discs. Though its cheap anyway. Very easy to use. Can be buggy, it either works well or will crash occaissionally. I think they have improved that aspect in V9.
I use Pinnacle Liquid Edition. It is superb. Can't fault it at all. Very creative. Very professional results. Very, very stable. Would recommend it. Only thing that lets it down is the titler - fairly basic titles - 2D, static pre-fx. All the other features are perfect, great effects, it renders (on CPU and GP) whilst you work so it is quicker that Adobe in that aspect. Good DVD authoring.
I tried Adobe and wasn't that impressed, didn't seem easy to use.
Feel free to email me if I can help anymore.