So far I have only really found 2 mystery games that I enjoy: Cthulhu Dark and Bluebeard’s Bride. I really want to try more games in the Gumshoe system, but I bounced hard off of Trail of Cthulhu when I played it once years ago.
There’s obvious issues where you cannot hide information behind rolls. But its also fairly hard to to even conduct a mystery where you hand out all of the clues. If you need to know the places to go and people to talk to, it still often turns into a game of “What is the GM thinking?”
I would really love to see more OSR mystery games, as they tend to toy around with basic role playing assumptions in ways that a lot of games do not.