I played through Knights of the Nine - Revelations and it was the most fun I've had in Oblivion in forever. I also played through The Lost Spires years go and enjoyed it too - but not as much as I enjoyed Revelations. I tried playing through the Gates of Astragard, but it was boring to me, just a dungeon crawler and I'm a svcker for great stories. I was wondering if there's anymore because I looked at the nexus for the top quest mods and it seemed like none compared to Revelations.

http://wiki.tesnexus.com/index.php/User:Deaths_soul/Recommended_Oblivion_Quest_Mods_List

That may help