Then comes the other dozens or hundreds of quests that will ship with Skyrim. What sort of quests do you like to see? Oblivion's Fighters Guild offered you numerous opportunities to hack and slash wherever you went. The Mages Guild offered you numerous opportunities to hack and slash wherever you went. The Thieves guild let you steal in some pretty creative ways, and the Dark Brotherhood simply gave you a target, allowing you to do all the rest (yes!). Back in Morrowind, we had guild conflicts, the Mages Guild had you search through Dwemer ruins, the great houses offered political struggles, and the temple sent you to each corner of the island.
I've been writing a quest mod for Skyrim, and I've been letting my creativity flow into my keyboard. I'm trying to strike a balance between violent quests, puzzle-based quests (riddles and the such), and persuasive quests. One of my favorite quests that I've been working out is a murder mystery investigation. The idea is that the host of a party was found dead in his bed, and the house was immediately sealed off so that you know the murderer is among you (inspired by Whodunit?). During your investigation, you must fend for your life while trying to distinguish the innocent from the guilty, as well as trying to understand if you can really trust any of the party-goers. I'm quite pleased with the ideas that I've already put into it, and I feel like it blends deduction, violence, and intrigue in a nice way.
So what is it that you look for in a quest? Feel free to use favorite quests as an example, as well as least favorite quests in order to offer some contrast.
Begin! (Please)