I think 480p resolution can look a lot better than people make it out to be. I reckon people's perception of it has been warped by YouTube serving dreadful low-bitrate 480p video for years.

On DVD: DVD would still look fine (I think) if you were still playing it through the same screen you did back then.