I went through exactly this process last year! I bought a Sony DCR-DVD202E
which I didn't get on with at all. Fortunately I had gone in to Dixons at Heathrow, told them what I wanted it to do, and asked for their recommendation, so getting a replacement was straightforward. I now have a Sony DCR-HC90E
Anyway, for digital editing there's only one recording media type - mini DV. It's a very small tape, about 70mm x 50mm x 15mm typically recording 60-90 minutes of video in a digital format. And there's only one method of transfer to PC - Firewire. Confusingly, Firewire is also known as iLink or DV in/out (some camcorders are out only) or IEEE1392. No DVD camcorders that I've seen have this interface.
Avoid hard disk camcorders (unless they've improved hugely!) and avoid using USB for video transfer.
I tried a couple of shareware applications for converting DVD video to .wmv but they were appalling!