I still enjoy the quests where you stumble upon someone dead and then have to find out what happened to them
Opening a book and getting a quest to visit different places is okay too
The Rabinna quest was a good one as you could conclude it in different ways - good, bad or a mixture of both - plus it gave some insight into the local lore