I fully agree. Vanilla Skyrim was kinda one of my worst RPG experiences I ever had. Quests like slaying a dragon, that allegedly was nearby, as it was told by the Jarl's steward (or whatever position he had), was in reality almost on the other end of the freaking map, in a completely different region, under a different Jarl. And the reward, something like measly 100 gold for all the stress, was just beyond laughable.
Or, and that is my worst one, is getting called by the dudes on the mountain. I actually had fun on my travel there, really felt like the chosen one, like Luke flying to Yoda. I stopped in villages to do some side quests and wandered on, to go up the mountain, seeing the vista, finding the monastery and getting greeted by hooded, Jedi like monks. I was really excited...
...and then I get three quick lessons in less then five minutes and they throw me out! Well, I got more then Rey got, but still, it seems like being the Dragonborn is worth Jack shit, so I modded the game to hell and back.
And honestly, it says quite a lot when mods make the game better and more fun then it actually is...