I used to have an old Plextor ConvertX (external capture device), but it's not compatible with Win 7 so I can't use it anymore. It used to work fairly well, although for some reason when it captured from VHS there was always a distortion line at the bottom of the capture.
If you're want to do it lazy man style, they sell VHS/DVD recorder hybrids where you plop the tape in one side and the DVD-R in the other side and it does it automatically. Those go for $150 ish from what I've seen at places like Costco. Most capture cards or external devices are going to have analog inputs vs. coaxial. Awhile back I tried to look for options and found a few in the $50-$80 range, but no clue on the quality of them. You can find them on Amazon and at Best Buy pretty readily.
The big thing is to make sure whatever device you get has an efficient capture codec, especially if your plan is to xfer old home movies that take up an entire 2-4 hour+ VHS tape.