[vertexmachina]

A detective game that actually makes you feel like a detective. That means gathering clues, using deduction, and making accusations.

Game Maker's Toolkit has a really good video on why it's difficult: https://www.youtube.com/watch?v=gwV_mA2cv_0

Return of the Obra Dinn and Her Story are the best I've played so far, each excelling at different things.

[bussierem]

You may want to take a look at the various Sherlock Holmes games on steam right now. There is a new one that just came out, and from looking thru them it seems like they try to make such gameplay work. Worth a shot!

[billfruit]

"Paradise Killer" may be of a similar genre. Also perhaps "Deadly Premonition".