I remember hearing about a mod that adds spells from Apocalypse spell package, Conjuration Madness, etc to NPC lists. Is there a such mod or am I just think of something else?

That's ASIS.

Ah that's it! Thanks!