RPGs like the Baldurs Gate sequel are very structured
Now Outward is a third person game made by an indie team, but the game has matured a bit now and they have released three DLCs. You got some factions, have to chose your build, cook food and sleep in the wilderness. And it has great outdoors areas that you are just gonna fall in love with, and really great music to go with the exploration. And the nature and creatures in the game actually reminds you of Morrowind. A real gem.
https://www.youtube.com/watch?v=nN8fSxg7cEs&ab_channel=Play4...
https://www.youtube.com/watch?v=rD0vqPnbQPc&ab_channel=PlayS...
Crafting games can be somewhat similar, where the main objective is more of a theme in the background.
Baldurs Gate is to my memory a game that focus fairly strong on the main story, and so I find the experience quite far away from Morrowind. In that game you did not look out and see a big mountain with wonders of what might be lurking there.
The worst part is that it's clearly set up for a third which will almost certainly never happen.
The de-protagonising is definitely a concern also, but I file that under the "Empire Strikes Back" approach (i.e the second can end on a cliffhanger (sortof)) which will all be resolved by the third.
The fun of an Elder Scroll's game, for me, is the sense of aimlessness in a world that doesn't feel structured like a quest-checklist, but like a world. Something I can poke and prod and truly make my own goals and activities in. You could almost call it "meta-fun". The individual actions aren't fun - some in Morrowind are almost painful - but the big picture is enthralling for someone like me.
But not everybody's like that; and not everybody likes them