1. I really like the "Nesingwary" type quests - where you run into the same NPC as you level. Sometimes, with hilarious consequences and tasks. I think it brings so much joy and immersion to your character and time in game. I would always look forward to seeing the NPC as I progressed through the game.
2. I also like quests with loyalty consequences. For instance, if you help one group who is at odds with their rivals, you are unable to use the rival's camp (NPCs, crafting stations, shops, etc) Makes you really think about which group you will help. (think oracles vs. puppy men)
3. I enjoy quests where you (for example) find pages to a book or parts to a portal - that you can later use to your advantage. Not all players would take the time to collect these difficult items, and you can become known as the one who "has that spell book with the amazing buff" or can "make that portal to the raid entrance" These will really set your character apart because you put in time and effort to complete the tasks required.
4. I hope to see quests where you help an NPC and learn more about their backstory (and maybe how you fit into the story) as time progresses. For instance, you come across an old lady in a dilapidated shack. She is heartbroken because all of her cats have run away. As the game progresses you find and capture the cats - other NPC's can even give you clues and hints regarding the cat locations, if you take the time to speak with them. You have to return to the lady and bring her the captured cats, and will find that she is a powerful mage and she can grant you an exclusive enchantment or emote or title - something distinctive and special.
You can probably tell, I really like long-form and immersive quests. I have so many ideas!