What games do you even like? Skyrim is seriously flawed, but saying it's not a good game is just ridiculous.
I won't adress your dissection of these quests - which indeed have several steps and different routes !!! - and directly answer you there.
I like a ton of games, crpgs or not. In the crpg category I like a lot of m&m games (mostly the tile-based ones, including MMX (the madman !)), the IE games (never played IWD2 though), the original Fallout (Fallout 2 not so much) and FNV, Kotor 2, The witcher 1&2 (3 not so much - are they rpgs ? I don't know, discuss !), ... and more or less related to rpgs, like Dark Souls games or Deus Ex. From the top of my head, these are the games I'd give. I think there's no doubt most of them are popular and/or triple A.
Just so you know I'm perfectly fine with these, as long as they're good. I legit find Skyrim mediocre despite its good outdoor scenery. FYI I also think Daggerfall and Morrowind are pretty bad as well, i'm not in a "bethesda has declined" situation. I think they always made mediocre stuff (as long as i'm concerned) with fun gimmicks like open world or infinite quests. I don't consider these good design elements - bethesda or not.
These quests you dissected aren't as good as the get out of jail one I mentioned. Some of them are even basic fetch quests with some choice at some point.
Reminder that we're talking about a game designed around the quest compass, and which becomes unplayable without it, so these quests steps never involve any sort of investigation or reflection. They're always straight-forwardly directional. You can enter the "lore details" as much as you want, but they're pretty much all bland and uninteresting. (Unless, yeah, the player likes the elder scrolls lore. But I don't particularly like it, so...)
All I remember from my last skyrim session is finishing the thieves guild quest, becoming a special agent of the lord of shadow or something, and be given a level-scaled bow and leather armor. I perfectly remember how cruelly linear this last quest was, and how I was supposed to feel immersed or concerned, but it just didn't work. I also remember how quickly this legendary gear of legend became subpar compared to the next dungeon loot.