I'm struggling to thinking of any dated sites that I use where a revamp would result in an actual improvement.

I can think of plenty where the revamp has made them much worse, Reddit being top of mind.

Linkedin, without any doubt!

Microsoft could have turned it into something much bigger and more useful by revamping the site after acquisition, sadly they didn't.

Google. It's nearly useless these days.