The issue with puzzles and riddle gates is that they are binary; you either get it and pass or you don't. In games they should be built so they can be achieved or circumvented in different ways. If a sphinx is demanding a riddle challenge you can just kill the Sphinx. If a dungeon puzzle can't be solved, the rogue can get at the mechanism and disable/open lock on it.