Will my old tapes look better after digitizing?

Digitizing captures exactly what is on the tape, faithfully. I can clean up obvious issues, but a worn VHS will not magically become HD. What you gain is a stable digital copy that will not degrade any further, plus the ability to actually watch it again. For photos, restoration is a separate service if you want fading or damage repaired.