I disagree on it being weird the thing that makes it great. No, it's because they cared. They wrote a deep intriguing story, and they trusted the player to treat the world as meaningful and to learn on their own. They expected you to read and to be interested.

Now, everything is dumbed down and simple, and it's baby fed to the player. There's little to discover that isn't shoved down your throat. Sure, there's (precedurally generated) loot to gather, but nothing more.

Morrowind was built as a world, and then they set a game there. The people, locations, and events make sense in that world. Starting especially with Skyrim, but even with Oblivion, it's built as a theme park. The world is just there to entertain you, but there's nothing behind the fecade.

Only a couple things need fixing.

No dice roll combat

Enemies don't aggro/prevent resting and saving from miles away

I wouldn't say that Oblivion or Skyrim has much better gameplay, honestly. Yeah the weird dice-roll mechanic is gone, not that dice rolls necessarily make for a bad game (see the entire Baldur's Gate franchise, including the latest installment) but the combat in Oblivion and Skyrim isn't exactly good. It's floaty and feels really weird.

Oblivion retains more of Morrowinds roleplay mechanics, too. Skyrim is just a flat, empty game. They leant really far into this garbage faux viking aesthetic, complete with rubbish accents (as a Swede, we don't sound like that here in the Nordics) and there's nothing really memorable about it. It plays and feels about as drab as it looks.

Like to-date, there are still aspects of Oblivion and Morrowind I recall fondly. One of my favourite wow-moments in Oblivion was the quest with the woman who tasked you with finding her painter husband. That's a fun quest. Skyrim has nothing like that.

I don't think it's just because it's weird. It's because it's weird and immersive. Part of what makes it so immersive is that there's no modern fast travel. There are in game fast travel options but they can only get you to major settlements, or fortresses that you've found and cleared, or whatever point you've marked that you can use the recall spell to. Beyond that your on your own two feet. You want to get to the Urshilaku camp? Better start walking because you can't fast travel there. And at the start of the game you're slow as fuck. I still remember it being quite an adventure to get from Seyda Neen to Balmora on foot.

And that's to not even mention the quests. I don't wish the for the Morrowind style journal, but the quests didn't have a huge waypoint telling you exactly where to go. If you wanted to know where you had to go you had to listen to the directions you were given and then actually try to follow them. One of my more memorable side quests from Morrowind was where I misunderstood the directions, took the wrong left turn and kept searching for a farm almost all the way to Caldera. The actual farm was pretty much just around the corner had I taken the right turn. I don't even remember what the quest itself was about. I only remember getting lost.