A lot of detective games are mostly point and click adventure games, which generally are older games or more indie style. That said there are a few I can think of:

The Gabriel Knight games have a lot of good detective elements, including some good puzzle solving. https://www.gog.com/en/game/gabriel_knight_sins_of_the_fathers

Chicken Police has a really neat interrogation mechanic and a fantastic noir setting. Its a bit silly all things considered, but the detective elements are fun. I’ve not beaten the game, but the time I’ve put into its fun. https://www.gog.com/en/game/chicken_police

In a similar vein, Backbone is a noir detective game set in an animal setting. The detective mechanics feel weaker, and the game seems to force you on to the critical path pretty hard, but its still been fun so far. https://www.gog.com/en/game/backbone

Finally, this is a horror game, but unraveling the mystery is fun and the game doesn’t railroad you on the critical path too hard. Simulacra is a game about a guy who receives a mysterious cell phone and he is using all the tools available on the phone to uncover the identity of the owner. Short and engrossing. https://www.gog.com/en/game/simulacra

Another one that I think is fun (though don’t get the sequel) is Don’t Feed the Monkies. This is more like Simulacra and is less detective game and more about experiencing the stories presented and unraveling a light mystery. Still fun and fits in the detective theme: https://www.gog.com/en/game/do_not_feed_the_monkeys

The Sexy Brutale is a really interesting game with more fantastical elements but there are some tricky puzzles to figure out with the clues the game gives you: https://www.gog.com/en/game/the_sexy_brutale

Last one, and one I’ve not played any of. Case of the Golden Idol apparently has multiple critical paths. Supposed to be really good. https://www.gog.com/en/game/the_case_of_the_golden_idol

Most of these are on sale now.