Upscaling a bad quality DVD will look bad. Upscaling a good quality DVD will only look less bad.
Good quality DVD's are only so so, as long as you don't get closer to your set.
If you do you'll want to throw them in the trash realizing there is no real detail.
Unfortunately for many TV series and movies there are only DVD, and for others the studios screw up the Blu Ray release.