I bought a cheap £300 JCV DV camcorder the other day for work and this is easy to set-up on a PC via a supplied USB lead combined with the supplied Imagemixer 1.5 for simple capture etc.
However I bought a Sony dcr109 (£450 Amazon) for my own use (not at all sure its any better quality??) - this has very poor software and transfer to PC is a disapointment.
I am getting a Firewire card fitted to my machine plus Pinical 9+ to take care of the capture and edit process (I hope).
Like you I bought the (desktop) computer to work with camcorders but had an analogue camcorder at the time - mine did not have a Firewire. I bought from a local small dealer so he is fitting the Firewire card and making sure every thing works with new camcorder for min cost.
cheers Paul.