It’s a little janky, and the blocky aesthetic may or may not be your thing, but it handles the idea of detective work better than any other game I’ve ever played. It’s not just “Walk around in detective vision until you assemble enough clues for the character to tell you the solution.” You have to actually think about things, examine the evidence, assemble a theory of the crime. Which is doubly impressive given that every crime is procedurally generated.
Dark Tide (Warhammer 40K). The combat just flows so well, and the relentless hordes of enemies lay on the kind of pressure that forces you to use every tool in your character’s arsenal to its maximum potential.