I don't care i just pay whatever it costs for more TES content, i have no free will

I am in the same situation.
(Some minor Shivering Isles spoilers below)Prometheus, I just finished playing through the SI main quest again. Yes, at their core, most of the later quests were fetch quests. But I didn't find them repetitive - there seemed to be a slight twist to each successive one. Things got even more strange and weird as you completed the tasks for Sheogorath. This time, instead of rushing through the quests I took the time to explore. There was a lot more story there than I remembered from the first time I played through the expansion.
You had to help either the Golden Saints or Dark Seducers take command over a holy place (choosing sides in general in the SI had major consquences at times), you had to placate a nasty Mages Guild reject if you wanted her assistance (you could also have a little fun "helping" with her research subjects), you could drive hapless adventurers insane, you witnessed the genocide of a noble race and attempted to bring them back to life - just a few examples of what was required of the player during these 'fetch quests'.
Not to mention, if you take the time to summon Haskill after each minor stage of a quest, you can hear some of the most infuriating and funny lines in the SI.
That said, I agree with you the Bloodmoon was an amazing expansion. (I still play that every once in awhile, with lots of mods for added fun.)
