I prefer Premiere Pro which I've been using since the first version, but the new version (CS3)is great. The bad part is it is relatively expensive unless you are upgrading. Premiere Pro CS3 also comes with Encore (for authoring DVDs, Blue-Ray discs, and exports to Flash), and OnLocation which allows you to connect to a laptop on location and operate camera(s) and other fine-tune your video.
There's also Premiere Essentials which is about $100 (full version) and $80 (upgrade). You can even upgrade from it to the Pro version.
I've used an older version of Final Cut Pro for the Mac (Version 3) which combined many of the features of Adobe Premiere and Adobe After Effects which was nice, but the Mac hated my $2000+ camcorder.
There are many others that are probably cheaper or even free. If you are only doing non-professional output, you may be able to find something for a lot less, but Adobe products, in my opinion, are fairly easy to learn and give you top-quality output.