The reveal at the end was very nice. But I was burning with questions, and Thaos didn't provide answers. You can only ask his soul ONE question, which is quite bad imo. I really liked when, in KoToR 2, you could talk to the last boss at the end. "No more secrets, only truth". We didn't have that here. I get that while Thaos is alive, he doesn't want to answer your questions. He is, after all, your enemy. But if his soul can provide answers, why not more? It simply didn't leave me satisfied, from a story perspective. It's nice to know what happens do your companions, and the rest of the world, but it seemed to me that your character does absolutely nothing with the revelation that there are no Gods. People keep believing. The Leaden Key continues its operations. A bit strange. In my ending, Durance ended up burning himself because Magran wouldn't speak to him. Did this revelation mean nothing to him?
Another thing, about the Gods: the quests were short, but that wasn't my problem. At the end, they promise you power, in exchange for doing their will regarding the souls. The god of Death was a pretty idiotic choice. Why the hell would you do that? And he was pretty hypocritical too: he didn't want to destroy the Pale Elves souls because "it will happen on it's own, in time", but when it came to these souls, suddenly he was in a rush. Anyway, I have decided to choose one course of action, and made a promise to a god. To all the others, I could just say "I have to think about it." or "I should listen to the others gods first". I should have had the option to refuse. Also, they all say "make a decision before the end", and I expected to talk to the gods once more after I had left the city, but this doesn't happen.
As for the last fight itself, I have enjoyed it quite much. I have died a few times during it (playing on normal), but it was quite satisfying when I won. I wish there were more boss fights like that in the game. The only other one that I can remember was Spider Queen, and maybe Raedric (although I did cheese that one a bit by positioning my party before the fight).