I also like Adobe Premiere Pro. I'm not sure what other programs can do, but I find Premiere good for dragging and dropping clips earlier and later in the movie sequence, adding cross fades between clips and adding an audio track.
In my experience, if I try to get too much more fancy than that, it ends up looking cheesy.
Chips