My friend bought the Pyro 1394DV package, and he uses Adobe Premiere for capturing, editing, and output. I believe he may also be getting into Avid DV Express.
I do all my DV work on my Powerbook using the built-in firewire port. I have a Sony MiniDV camcorder, and I use it mostly for outputting animations to tape. Any footage that I capture tends to be either client stuff or my own goofy things (parties, family gatherings, me chasing my cat around, etc.). I also use my DV camera as a video source on a make-shift animation stand when I do traditional stuff.
For software, I use Final Cut Pro for most things. I also have a couple of shareware things I'll use for quick video captures and frame-by-frame capturing (the traditional stuff).