The only cool vanilla questline is dragonborn, because you literally partner up with Cthulhu.
What could you do in Oblivion?
GO ON A FUCKING HOLY CRUSADE
And you can....kinda do it in Skyrim. But there's no quest for it, you can just maybe put together a crusader outfit