Isnt it always us hyping up something? Heh, I think we will be Dovakhin, he doesn't have to be Emperor. Look at Nerevarine, didn't have to be ruler of Vvardenfell, and hdidnt.
You can't simply compare the Nerevarine to the Dragonborn. They have completely different history. People here who say that it's likely the Dragonborn should rebuild an Empire and become the new Emperor have a point because that has happened before with people who were called Dragonborn.
What I'd like to see is that the Nords know of a prophecy that speaks of the Dragonborn, but nobody knows who he is - similar to the story of King Wulfharth and Tiber Septim (who was then called Hjald, I believe). Wulfharth thought "of course I'm the chosen one, who else could it be?!", and then it turned out the chosen one was some very young guy from High Rock.
The various leaders in the civil war could all believe (or make others believe) they're the Dragonborn, for example. That could be interesting. But I don't know. There are just three things I'm concerned about:
1) I don't wanna be a lame sidekick with no own initiative like in Oblivion.
2) I don't wanna be pushed into being some awesome supermighty dragon-fighting warrior - heck, I wanna play thieves and mad wizards.
3) And I definitely don't want to be the Emperor or a God at the end of the story. Seriously, the reward of Shivering Isles was already too much for my taste, I don't want that to repeat (although in general I would like something like Shivering Isles very much). Most of all, I don't want history in later Elder Scrolls games that sounds awkward because a certain name is always left blank and the character's race and gender are never specified. That would svck.