Couple of things:
1) The Dazzle DVC II is a great unit once you get it up and running. However, I've seen very few pieces of hardware that have polarized users like the DVC II - some users rave about it, others want to sue or kill Dazzle. The consensus, though, is that you shouldn't quite expect a Plug-n-Play experience with it, and make sure you check all the support sites for help on capturing and editing. Once it works, it works very well.
2) The Movie Maker is apparently much closer to a PnP capture device - then again, there's no PCI card involved. I considered it, but I want something with a higher capture resolution that won't require resizing. BTW, it's rumored that Creative is going to release a FireWire version of the Movie Maker.
3) If you've got a fast CPU and LOTS of hard drive space, a low-cost option is a cheap TV card with video-in. Most cheap TV cards will do good-to-excellent uncompressed video capture which you can later compress with the codec of your choice. The downside is the time required to compress the MPEG2/4 if you have a lot of video to process. I've just started playing with this and it works pretty well, but I'd prefer a real time compression capture device.