It very much depends on the game. If I'm running D&D5e, or pretty much any level based game, where the players are expecting their XP total to tick up regularly, I tend to go for dungeon crawls with a thin veneer of plot over the top, as that fulfils the requirement for progress while still...