Final Cut Pro is pretty good. Final Cut express should be good too, but it's only for DV files. If you have an output card(analog) that would be fine. iMovie is pretty good too, for a free program. It's got fades in and out, numerous effects, 2 audio tracks, and comes with a bunch of little things that make it a great program to edit in.

On the PC side though, I'm not real sure. I think Avid is coming out with a free DV editing solution, so check there.