You can not expect to see better quality than the original source. I have a Pioneer combo unit that I use to convert the old home VHS tapes to DVD. I believe there is some noise reducing circuitry built in as some of the conversions seem too look a little better than the VHS tapes, but nowhere close to the quality of a DVD recording of the original source.
I would not spend a lot of money on the equipment. If you have a good VCR, any DVD recorder hooked to it can suit your needs. If not, the combo units are easier and more convenient to dub the tapes to DVD.
Either way, you are going to end up with VHS quality on a DVD, not a digitally remastered DVD.
I'm planning to buy video editing software, probably Adobe Premier, so that I can load my family VCR tapes to the computer, do some editing, then burn DVD's. My question is; if I buy on of those VCR/DVD Recorder units that claim to "Upconvert" the regular VCR output to "near HD" will I really be abel to get much better resolution to the computer, even when I burn the DVD? Or is it possible/better to buy a video scaler for this? Or is it wishful thinking? Thanks to all you video editor experts on the forum.