Wow! This one blew me away at the end. Without giving away any spoilers, I thought the first two 'acts' of the quest were sort of cute, if nothing terribly memorable. I can see now though after finishing it that the writer was setting the player up for an extremely powerful ending. In fact I would say possibly the most emotionally powerful ending of a quest I've ever seen in any RPG. And coming as it did immediately after a fight with the toughest vampire I've yet encountered in Skyrim, well, I was floored! Those of you who've not done this quest definitely need to check it out. Despite the usual Elder Scrolls/Fallout bugs and glitches, Skyrim overall has been an amazing gaming experience.
PS.....After doing that amazing quest I'm now sort of anxious to do the Temple of Dibella.