I've been working on transferring video from VHS, digital 8 and miniDV tape for several years. I do not have any experience with dedicated capture cards. I'm sure they're fine.
I would caution you to stay away from USB based transfer. I had several issues with VHS audio / video synching correctly with a USB system. I believe that this is because USB is not dedicated to the capture process as it continually 'polls' existing USB ports for potential activity. I used USB 2.0 exclusively. I know that 3.0 is faster, but I do not know if it would behave any better in regard to avoiding synching issues.
I ended up getting a Firewire card. Although this is somewhat dated technology, it works well and is 'dedicated.' Further, the cards are relatively cheap and my digital 8 and miniDV camcorders were equipped with Firewire ports. Also, the miniDV camera had an analog to digital passthrough circuit on it that allowed me to connect a VHS player to the camera and easily digitize VHS tapes.
I've used Sony Movie Studio software to capture, edit and create DVDs. It works very well and is pretty powerful in regard to editing. It may be more than you need, but it is reasonably priced and, like most software, you can just use the features you want and ignore the rest.
Last suggestion I have is VLC Media Player. It's freeware that will allow you to put DVD video on a flash drive and have it behave exactly as it would on a DVD player - choose chapters, etc. You can put more than one video on a flash drive. All you need is sufficient capacity and separate folders to hold each video along with its own copy of the VLC player. It will run on hard drives as well. Again, all you need to do is set up separate folders.