Oblivion had something; it gave you a reason to fight and it was not just in the main quest, it was all over; from the main quest to the guilds and even side quests. In Skyrim it’s mostly, fetch me this and deliver that. Then you have the Main Quest, which I would hardly call “the need to stop this now” factor.
Sure, dragons attacking is bad, who wants that? However, it is no different from a gang of bandits destroying a small village. With the Dadera, they left chaos and carnage wherever they appeared. You saw an Oblivion Gate open up near a city and I was like “Oh sh!t, this cannot be good!”
In Skyrim I see a dragon flying above my head and it’s like “I don’t have time for this.” It is neat the first time, but after while; it is like a gnat buzzing in your face on a hot summer’s day. Hell half the time it was nice seeing a dragon flying over a city and killing people, because most of the people I did not like, you were able to use the dragon to kill someone without getting in trouble for it.
I was hoping the main quest would be beyond that of Oblivion’s main quest. The main quest in Skyrim started out good and stayed that way until you went to retrieve the horn, after that it just spiraled out of control and dive-bombed fast. And I will not go into a rant about, how bad Delphine and/or the Blades are, I would be here for hours typing. The main quest was like, trying to enjoy lemonade without sugar or ice, it was dry and simply bland.
Dragons could have been added as a standard encounter in the wild as you do with wolves, trolls or even bears, but then again lore would not match up correctly. In my opinion, I would have preferred being a part of The Great War, reading the books that sounded like it would have been interesting to take part in.
The main quest in Skyrim also suffers from the Civil War going on at the same time. It was not exactly perfect by any means, but it also caused the player to choose a side, but some players chose not to get involved in such political squabbles. I think throwing in a political squabble with the dragon issue creates too much going on at once, leaving the player confused and disoriented on which is the more important “crisis.”
I remember when I first got Oblivion, I was glued to playing it, hell when I woke up and finished my normal routine, it was back in the game for hours on end. With Skyrim, I can play for a few hours, shut it off and I do not really think too much about it. I just don’t have that same need to play it as I did with the previous game.
Honestly, I do not know what happened; I was super hyped to play it, I get it and after two months, I am already starting to become bored. The main quest, the civil war and some of the side quest I feel are no longer worth investing my time in.
You know, I did the main quest for the Mage’s College and it took me 3 hours to complete it. I did the main quest for the Mage’s College in Oblivion and it took me almost five days to complete it.
I am simply astonished by how beautiful the game is, but when it comes to quests, especially guilds and the main quest, I want to feel like the hero, I want to be the hero; I want to feel like I earned my title in the guilds.
To wrap things up here, I feel like the developers let me down and I just hope the next Elder game makes up for it. I want more in my Elder of the Scrolls game, not less. You can make the world look as beatiful as you want, but in the end the stories are what matter most to me.

In fact a lot of people will tell you the main quest is not the reason to play the ES games.