What's the reason of people's obsession about Skyrim and modding it? Don't get me wrong, I am not asking it in a condescending way; if you have fun, more power to you. But to me Skyrim was an offensively bad product, so moving on was the best thing I could do. So I'm geniuenly asking, what's it appeal? Did modders found solutions to poor writing, uninteresting exploration, brain dead combat, awful animations, shitty engine etc... ?
(I have never played "Special Edition" by the way; last time I played it was about a decade ago)
Modders have done a hell of a lot with the game, considering its age, they're always stretching the capabilities of the engine, and there's enough variety of modders' tastes out there that it's possible to mod an experience to your liking, whatever that may be. And as Lemming42 said, it's also fun to mod once you get into it - it's even a potential gateway into learning a little bit of scripting and programming, or 3-d modeling, texturing and all that, if it starts to grab you and you start modding yourself.
And for all the bad words one might have about Bethesda, they have created the most easily and comprehensively moddable games out there. So naturally people take advantage of that.
But even at an end-user level, you have to learn to be careful and systematic about things, which is nice. It's a great feeling when you iron out the glitches and get your set of preferred mods working (it's a feeling rather like when you build your own PC and go from, "Why the HELL isn't this hunk of junk working?" to, "Aha, it's working now!")
The downside is that it is quite time-consuming, and in a given "bout" of playing Skyrim (I've had like maybe half a dozen over the years), you might or might not end up actually playing the game for any length of time

Modding is basically a hobby within a hobby.