For mpeg2 -
If you don't need to edit the source (other than chopping off the beginning or end), Vidomi seems to be a very good all-in-one program. If you have to edit the source (cut out commercials or something), I have yet to find anything useable as everything I've tried so far produces horribly off-sync audio (mpeg2 that is, never tried mpeg1).