I know that Dazzle makes a capture card with software, but you get better results with a DV camera and Firewire - it's all digital.
The Dazzle (PCI card version) is about $200, and uses SVHS or Analog RCA jacks to capture from TV, VCRs, etc. The only good thing is that it will capture PAL or NTSC. I lived for 9 years in Europe (6 in NL, 3 in D), and have some PAL tapes - so I bought a PAL/NTSC VCR and used the Dazzle card to get them to PAL DVD that I can play. I also have PAL DVDs - Allo, Allo and Corrs Vids - but just converted the DVDs to region free and left as PAL (many DVD players can play either format on either TV).
I would recommend Pinnacle Studio 8 to capture from your DV camera to your PC. It can also make the DVD for you if you want an all-in-1 package. Otherwise, there are other programs that are not too expensive to author the DVD from MPG to VOB format to burn. If you don't have a DVD burner, you can also convert MPG to SVCD MPGs and burn to regular CDRs to play in a DVD player, but the full quality of the DV camera will not be had... :-(