Two main option:
(1) send it somewhere, and let the professionals handle it; and we are an option you should consider
(2) the DIY method, and we help with that in the forum
If DIY, I would get this:
http://www.digitalfaq.com/forum/mark...-workflow.html
That's all you'll need: JVC Pro S-VHS VCR for best quality, a green AVT or 1000 TBC, and USB capture card for the computer. That 600 can capture to MPEG or lossless, and then MPEG can be burned to DVD with minimal effort (DVD burner required). Tested gear from a reliable person.
Most of those combo decks are pretty miserable, especially anything non-pro. If you liked that sort of machine, then he also has a JVC Pro LSI DVD recorder available for sale, includes TBC, under $500 shipped. All you need with it is to use good blanks, and teaching you want to get for it is easy enough. Unlike those consumer machines, it plays nicer with blank discs.
A quality setup that gives you no hassles costs between $500 and $1k. Anything less gives you problems, as you're now seeing. That's just the nature of video.
Having 40+ VHS tapes professionally work on will be about $800+, depending on length. Sending it out is easier, about the same costs, but you have more control if you do it yourself. It's all about choices, and what you're most comfortable with. We can help you either way.