It's the media hype that leads people to believe it's either going to be the best damn game in the world, or a horrifying disappointment.
However, if people were to try and take Skyrim for what it is, it's a pretty damn good game with a solid, even if cliched story.
Skyrim to me is a major improvement over oblivion on every area. The combat is much more intense and interactive (simply moving back and forth while striking isn't the end all tactic like it was in Morrowind and Oblivion), spells are far more dynamic and balanced (no powerleveling the shit out of alteration just by casting it while destruction is left behind), the NPC's while redundant, at least have far more interesting things to say (I'd TOTALLY fucking take the Arrow to the Knee comments over "I saw a mudcrab the other day, disgusting things. Bye."), and there are countless other things that work so well in this.
Is it perfect? Absolutely not. Does it have flaws, more than enough to occasionally break a game. But, if you can look past some of the inconsistencies, flaws and bugs, it can be a great gaming experience.
That said, if you can't look past the bugs/flaws in a game as massive as this then no, you won't enjoy the game and you're also kind of an idiot to think that this game would be perfect.
Bethesda isn't about perfection; their forte lies in scale and epicness. Bit by bit, they're improving their formula for combining that with the "Be whatever you want to be, and do whatever you want to do" sort of gameplay and while I don't imagine the next game will be the golden ticket either, personally, I'm patient enough to give them a chance.
After the catastrofuck that was oblivion, this game fixed about 90% of my issues with oblivion and gave me a really wonderful experience, and while I hated bethesda before for what they did with oblivion, I can't overlook how much they've improved and I think they deserve some credence.