Yeah, it's cool. It was mainly the history of Nirn and the different Eras that got me hooked. History nerd here.
I find the Merethic and Mystic Eras to be much fascinating.
Also, their phanteons and lore behind all the different races is great. Imga, Sload, Akaviri, Nede, Uxhaal, Manmer, so much cool stuff. Daedra is beyond cool too.
I do not know why but when I learned about the Akaviri in Oblivion, I was instantly interested in them because of the cool name.
Btw, thanks for the post on the books about the guys that had been to the moons. I find it strange that UESP wiki did not find it. Maybe I needed the names of the books, instead. I know nothing about the others you have listed.
About the lore contradicting, I see it like in the real world, there are so many 'thoughts' on how the world was created that it is up to us to decide who/what we will believe. And in the TES lore it is the same way, we play as a certain character and we can follow what 'we' have been taught or we can follow what some other race has been taught, again up to us aka the character.
The book writers are good in TES, even if the game itself is buggy, the books are at least for me are interesting.