The dwemer were, at first glance, superb craftsman and scientists, who left behind excellent weapons and armor, and fabulous machines that some of the best minds in Tamriel have struggled to understand for generations. If you look at them more carefully, however, you realize that there is much to them that is hard to understand; indeed, their values, goals, beliefs, and way of life seem almost incomprehensible.
A subplot in TES III: Morrowind, was seeking out the fate of the Dwemer. The Nerevarine encounters the last of the Dwemer, a guest of the great Dunmer sorceror Divayth Fyr, who tells how he was separated from his people, how he has searched for traces of them for centuries, but no trace can be found. It is known that the Dwemer vanished, all at once, when the tonal architect Kagrenac used his tools upon the Heart of Lorkhan, at the end of the Battle of Red Mountain in the First Era. What became of them is uncertain. The dominant theory, hereabouts, based upon a comment by MK, is that they became the "golden skin" of Numidium, also known as the Brass God, which was engineered by the Dwemer to transcend a universe they found unsatisfactory. Whether their fate and that of Numidium would be considered a success or a failure by the Dwemer, and whether that is even a meaningful question, remains a mystery.