i'm a huge Morrowind fan, and we already know that the player completes the prophecies, becomes the Nerevarine, and defeats Dagoth Ur in red mountain by severing his ties with the heart of lorkan. After that the hero Nerevarine takes off the akavir, leaving Vvanderfell un portected. (vivec doesnt count) After that lore tells us that oblivion gates open up every where in Tamriel and Ald ruhn is destroyed. After that the floating city puts in some work offing most of the populace.
My question is. Wouldn't it be better off for morrowind if Dagoth Ur did what he actually planned to do? Complete the akulakahn and drive the imperials from morrowind. But he would still be around when the gates opened up. I don't think he would want Morrowind to be destroyed by deadra.