come on, the'll never tell us what happened to the dwemer.......
A man can dream. can't he?

Why dream? The answer was given in Morrowind, specifically the Mages's Guild questline. Basically, they're all dead. High Engineer (How cool is that job title?) Kagrenac used the Tools (Keening and Sunder) on the Heart of Lorkhan in a desperate attempt to turn the tide of the War of the First Council. Faced with the prospect of defeat, he risked (And lost) his entire people in an attempt to ascend the Dwemer to a level of power even greater than the Dunmer Tribunal.
There does remain the possibility they exist, but in a realm independent of Nirn, so for all intents and purposes, they are dead, with no hope of crossing the Liminal barrier into Nirn, should they have actually been transported.