The main thing is don't try to come up with one huge riddle for the whole quest. That leads to half your guests getting stuck at the first station while the rest are bored. And don't overcomplicate things either: the most successful home quests are when the riddle is simple, but it takes a bit of searching or thinking. And forget about hiding clues so cleverly that nobody finds them. Test the route yourself before you start.
Start from the end: where will the final clue lead? Usually it's a prize that's already sitting in one of the rooms. Then work backwards - what rooms do you have, and how can you logically set up the stations. You can leave a task in the kitchen related to food or drinks. In the bedroom - something with a mirror or clothes. In the bathroom - water-themed riddles. You don't need more stations than rooms; 4 - 5 is plenty for an hour of gameplay.
For each station, write a riddle on a piece of paper or a card and leave that right where it's visible. Next to it - the answer itself (in an envelope, for example) that reveals where to go next. The key thing is making the clue match the room: if the quest is in the kitchen, the riddle should be about food, kitchen appliances, or groceries. Write riddles with your guests' difficulty level in mind - not too childish and not olympiad-level. And definitely have a backup plan ready in case someone gets stuck: either a leading question or an easier version of the riddle.