If I remember right there is a Plugin with which you can become a false god too. Trr Kah or Katan should know better.

What the "gods" have changed? Almalexia became totally crazy and killed Sotha Sil (who was never really interested in becoming a god because he was more a scientist) And Vivec was bored Something like that he says in the conversation with him.

And yes, Dagoth Ur became crazy too when he used the "Heart of Lorkhan". A thing with such power are not made for mortal people. It's much too much for them.