I do recall the final few Theives guild quest in Oblivion being well done. They were absurd fetch quests, yes, but all with a purpose. You needed the weird arrow, the boots, and some other mcguffin to get the biggest mcguffin of them all, an elder scroll, from the flipping Imperial Palace.