Dungeons are simply not the right thing without a puzzle, and other adventures can profit from a good one, too. Is it not cool to find out how that mechanism works? It is one thing for your character to kill dem monsters with bulging muscle or fiery spells (and the right die rolls, duh), but another is to defeat something with YOUR mind, to overcome an obstacle with your smartness only...