I see no problem with the inclusion of dragons in the game, in itself. Dragons have always been in the Elder Scrolls, and while they've generally not actually appeared in games, as I understand it, there's one in Redguard, so there's already a precedence for them in the series, and it's not like Bethesda is just pulling things out of the void so they can say their game has whatever is popular in main-stream fantasy right now. Now, I might be a little surprised that dragons are in the game because it's not the first thing that I would expect to see in the Elder Scrolls, especially when a game that takes place in the center of an empire that reveres them still has only one, and one that is actually the avatar of a god and only appears at the very end to deliver a well-timed deus ex machina, and therefore, in my mind, dopesn't really count, but I'm not bothered, I'll only complain if I feel they're not done well, and right now, we have absolutely no basis to assume they wont be, seeing as we still have very little information about the game, and I wouldn't be surprised if Bethesda will give only limited information about any dragons in the game to preserve the surprise.
I hope that dragons in the game are suitably epic, there should only be a few in the game, probably, and they should be important, if they do play the role of antagonists at all, they should be major bosses and villains in the game, not just random monsters for the player to fight. Though to be perfectly honest, I'd prefer if they're not enemies at all but rather are characters the player deals with in quests, maybe with a similar role in the story to Vivec or possibly Azura in Morrowind. Whatever role they play, though, if you fight them at all, it should be appropriately difficult and epic.
The least Cliche dragons I ever saw were in a movie called Reign of Fire, the dragons were awesome because they weren't mystical in anyway.
That's because the movie runs with the whole "Let's take a supernatural concept and say it's completely scientific and not magical in every way!" which often serves to completely ruin the concept, and really is VERY cliche, I just can't think of that many examples of it specifically apply to dragons. And in any case, when your setting already has a explicit examples of magic, doing that sort of thing seems to be quite counter-productive.