Objectively speaking, Skyrim really is kinda overhyped. But something really has to be said for the sheer volume of stuff that there is to explore in Bethesda games and how good it feels to explore all of that stuff, to delve into forgotten ruins and seek lost treasures and discover eldritch horrors. As a roleplaying game though, it never really felt right to do all of those things in one playthrough, and the writing of many of the subplots seems to agree with that premise, that you'll dedicate a whole separate character to each arc. I'd say that that is kindof a failing on the part of the writing team to not craft a cohesive narrative across the subplots but eh well, they did rope me into over a thousand hours of exploring the tundras and forests of Skyrim so I guess they did something right.
Hell, I've even tried getting into glitchless speedruns of this game. I'm not particularly competitive by any means, but with a current personal best of 5.5 hours I think that's pretty alright. Works well as a party trick at LAN parties too.