It depends on the quality of the results you need. I have only done this once before, but I used a VHS to video in, combined with Roxio's Easy CD (Media?) Creator 7. It gave reasonably decent results when compared to the original videotape, and was pretty simple to use for basic material.

Sadly, I suspect you will trade ease of use and convenience with quality, no matter what package you choose.