I've used a few, for the beginner you'd probably want to steer clear of things like Adobe Premiere or Final Cut - they are way in depth.
I think I finally settled on Ulead Video Studio, which was fairly easy to use. I went from source video, did edits, and then burned to DVD, although it was a somewhat slow process.
If you have access to a Mac, or think you're going to do enough editing to justify the purchase of something like a Mini (I think I got mine for ~$600 or so), or you feel up to the challenge of a hackintosh - iMovie is by far the best app you'll find for entry-level/amateur video editing. I finally decided to buy a macbook because of it.