I thought this would be a useful thread to make, to sprout some ideas for quests! Post all your story and quest ideas her that you're willing to share.
I'll post one of my old ones!
Resurrection and Renewal: Link goes on a quest to find out what happened to his sister, who disappeared after his grandfather dies unexpectedly. He learns that he must grace against the clock to get three relics before the enemy does. But this comes with a catch. One someone with a good heart touches the Gate to Heaven (Or something specific, really), the world will be destroy and start anew. If someone with an evil heart touches it, the world will simply become destroyed, with no life onwards. (If you want the full story, feel free to PM me)