I feel that the main stories in Bethesda games are not that great. Oblivion, Fallout 3, Skyrim, none had great "main" stories.
But what made these games feel great was the little things, the little stories that could easily go untold. Like in Skyrim, where i see some prisoner get escorted by Imperials. The same kind of Imperials who tried to have me bluntly executed without due process just moments before.
I felt compelled to kill the Imperials and rescue the prisoner, regardless of why he might be a prisoner. Some kind of revenge. And the world of Skyrim was full of these little things.
And through these little things in the world they don't so much tell a story but have the player experience his own story based on how they react and interact with the set pieces. As such the "main story" always felt secundary to me, because it was far more directed as a clearly defined story had to be told.
So yah, the story has never amazed me much, they were decent, good enough to play through at least once, but it was the world itself that they created that told the best stories. It is just as Todd Howard's story about trying to get a coffee mug in Fallout 4, like that i have many fond memories of funny little stories that were not planned but just happend.