As an ATI owner, I'm going to recommend getting an ATI All-In-Wonder Radeon card. Use this card along with the newest version of ATI's MultiMediaCenter software and you will be able to get some decent captures from your VHS tapes. You will hook your VCR up to the ATI card most likely with RCA cables.
You can preset the ATI software to capture to VCD or SVCD and then use somting like Nero to burn it to a CD to watch on your stand-alone dvd player.
Here are a couple of great websites for all the resources you need on capture cards, software, how to capture, etc...:
http://www.dvdrhelp.com
http://www.lordsmurf.com