I've always disliked VHS. Broadcast TV was available for comparison at the time and it looked much better.

DVD resolution seemed fine to me at the time - it does not seem fine anymore.

Cassettes were not great, not terrible compared to CDs. That is still the case because stereo audio doesn't get much better than CDs.

Conclusion: Whether something seems good at the time depends on availability of something similar but better.