The easiest to use is generally thought to be VideoRedo:
http://www.videoredo.com/en/index.htm
There's a version (VRD Plus 50 USD) for editing MPEG2 footage extracted from DVD, and another (TV Suite 75 USD) which will put the edited material back to DVD. In my experience the 'TV Suite' version is the better option although more expensive.
If you're feeling adventurous then MPEG Video Wizard DVD (99 USD):
http://www.womble.com/products/index.html
...gives a larger set of features, such as transitions between edits and an export function to iPod or other media players (and of course to DVD). They have cheaper products which don't author to DVD but sometimes this is not necessary if you have a DVD player which will accept bare MPEG2 files of <2GB.
The good thing about either of these applications is that they don't re-encode the video unless absolutely necessary; and then only where the edit point is. In my experience, almost every other easy-to-use MPEG2 editing tool re-encodes the whole file.
I'll transfer this to the Video Edit Software forum..