I am using Vegas Movie Studio + DVD, it is a watered-down version of the professional 'Vegas' software, but in my opinion, it's the best buy for around $100.
It allows you to pan and zoom on images, use the chroma key green screen effect, includes dozens of fully customizable transitions and effects, makes very high quality videos, etc. etc. It also comes with a full DVD authoring program and sound effects cd.
Gawd, I sound like a commercial , but it is a very good editing tool!