I fell into both.

Bought Skyrim on PS3 a few months after it came out. Had an absolute blast and it immediately became a favorite for my wife and me. The load times were terrible and there were bugs, but the bugs were usually just funny visual glitches. The DLC came out and was fantastic - I still wish they released more.

Eventually built a new gaming PC. My wife really wanted to try the earlier ES games so we bought the physical PC pack with all of them in it. The load times were way better with an SSD. The graphics and frame rate were way better. At that point patches had fixed a lot of the bugs.

I tried some mods and found that most of them aren't even worth the time it takes to browse for. 80% are just adding softcore porn that ruins the aesthetic. Another % are shit posts like replacing dragons with a model of Thomas the Tank Engine or replacing bears with Shrek- funny for maybe 30 seconds but not worth actually playing. 5% are other weapons that are just overpowered. The I'd guess about 4% are decent UI and graphics mods, some of which have since been rendered obsolete by newer editions. Probably <1% is actually good new content that I'd want to play, but even most of that isn't as good as the base game.

It's a similar situation with tabletop homebrew. Everyone and their mother thinks they have some great ideas, but in practice they usually aren't as fun as the main product. It's hard to compete with a corporation spending millions of dollars to pay people to work things out.

Add in how annoying it is to mod and how, even without any updates, it tends to break things. Skyrim has a reputation for being a broken and buggy game, but in my experience on multiple platforms (I eventually got the Switch and PS4 versions too lol) it's really pretty solid. Back in the day when it was common to see posts complaining about how buggy the game was, 90% of the time you could dig into it and find that the OP was using a crap ton of mods.