Still in early stages, but want to have a reference point in the forum:

Katatheosis
A Quest Mod by Qutayba

What happens when a god ceases to be a god? What happened to Vivec? Is Talos still a Divine if people stop worshiping him? Did the Nerevarine retire from Reincarnation? The elderly Dunmer scholar Solyn Vilmasi wishes to know the fate of ex-gods before he passes into the beyond. Will you learn the history of the rise and fall of divinity and set the old man's mind at ease?

Katatheosis is a lore-driven adventure that adds about a dozen dungeons and areas to explore. It is lore-friendly and lets TES ambiguities remain ambiguous. Meet some old friends and make some new ones.