Gaming

The Return of the Obra Dinn is by far the best detective game I have ever played.

This game (Shadows of Doubt) is in early access but is super promising so far. I'm in love with it!

https://store.steampowered.com/app/986130/Shadows_of_Doubt/

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.

This might not fit what you're looking for, but the Phoenix Wright games are mostly about detective work, despite playing as a lawyer. If you like wacky and surreal, the series should be right up your alley!

I had some weird bugs replaying it recently but maybe you'll have better luck than me - Orwell

Cloudpunk is more of a delivery game that has a mystery aspect but I enjoyed it (haven't finished it yet)

CaseCracker was enjoyable but there were some translation issues I think so some things weren't clear in English.

I haven't played either of these, but they sound very cool and have been on my wishlist for a while:

• Metaphobia - a FREE game on Steam. It's a classic-style point-and-click adventure in the vein of Gabriel Knight.
• Shadows of Doubt - An immersive sandbox detective stealth game set in a fully simulated sci-fi noir city of crime and corruption. The world is procedurally generated and you can explore and take on cases freely. Discover, meet and tail individual citizens, each with their own name, job, apartment and daily routine, in unique, procedurally-generated cities. Each case has different culprits, clues and experiences for you to test your investigative skills.

Would Phoenix Wright: Ace Attorney fit your bill? I mean it's mostly about moon logical deduction but also finding clues and such.

Have you played The Wolf Among Us? It's a Telltale adventure game, so in terms of gameplay it's more like an interactive graphic novel, but the story is great, and the detective work and interrogations are really immersive.

LA Noire was really fun on the steamdeck. Low key wish rockstar would make #2 instead of all that GTA RDR stuff..

Perhaps a point & click adventure would be a good fit? I’ve played and quite enjoyed The Blackwell Legacy and I’ve heard good things about other games by Wadjet Eye.

Return of the Obra Dinn is a very good game about piecing together clues to find out who everybody is and their eventual fate.

It's a different style, but Ghost Trick is being re released in HD very soon. I definitely recommend you give it a try!

If you like puzzles while soving a mystery I would recommend any of The Room games or Agent A a puzzle in Disguise.

You simply must play Technobabylon.

The gaming industry is so consolidated and really needs to be broken up IMO. So many games that could of been but didn't happen because some large corporation bought the rights and just sit on it or fucked it up. Embracer owns a ton of smaller developers and publishing studios as well. Like the publisher for Valheim is owned by Embracer.

I wouldn't rate L.A. Noire too highly, as it's a weird hybrid between detective game and GTA.

What rubbed me the wrong way was the illusion of choice in side quests (roadside police work) where it seems like it's always the worst possible outcome. The story, especially the choices my character made (without me having a say in it), wasn't to my taste either.

Has nobody recommended Aviary Attorney? It's a bit wacky, but in a good way, takes a good chunk of inspiration from the Phoenix Wright: Ace Attourney games. Some good mysteries to be solved.

Murdered: Soul Suspect casts you as a detective solving your own murder from beyond the grave.

I play pretty much everything. Some of my friends rage quit stuff when Im still 100% calm.

When it comes to BRs specifically, they can be very frustrating. Your winrate is inevitably low, due to there only being "one" winner per match, but me and my friends enjoy both Apex and Hunt: Showdown.

In both cases we started having a lot more fun when we started taking the games much less seriously, and not caring about whether the game told us we won.

In Apex, instead of wins, we'd count squad wipes. We began playing much more aggressively, not caring as much about out gear, and going TOWARDS action instead of away from it. This led to less time "wasted" meaning if we died, we did so fast and early, and so wed get to the next game faster. If we won, we'd score gear off the players we just defeated.

Similarly, in Hunt we'd head towards the first firefight we could hear, and either get kills or get killed. Pretty much always playing free hunters with cheap loadouts we wouldn't care about losing.

And never, ever, even considered caring about or grinding rank.

I play to maximize fun, not progress. I min/max for enjoyment, not stats. It's one of the reasons I have chat entirely disabled in Overwatch, voice and text, because I don't wanna hear it if someone is screaming at me over my pick. I don't care. I here to have a good time.

Observer System Redux with a performance from Rutger Hauer. I've just started it so I can't vouch for how good it is but it has positive reviews and has been pretty interesting so far.

It's absolutely not a detective game per say, but if you'd like an experience where you're trying to solve something and piecing together clues and secrets, then I'd really recommend Outer Wilds. You don't play as a detective, but you do get a spaceship and there is a lot of detecting to do!

Not exactly detective but the zero escape series is all about finding out mysteries

Murder by Numbers - it's picross + detective visual novel. While the core gameplay is nonogram puzzles, the visual novel parts involves finding clues and interrogations as an amateur detective. Probably not exactly what you're looking for, but it's a surprisingly fun game and I highly recommend it.

Tales of the Neon Sea is a nice cyberpunk adventure based detective title.
Gemini Rue is similar but more dark and in the tone of Blade Runner.
Sherlock Holmes: The Devil's Daughter is another really great title, although its more of an overarching story told during/through the various cases.
Call of Cthulhu is a detective story set in Lovecraftian horror. Really great endings.
The Sinking City is an open world detective story set in Lovecraftian horror. Gameplay outside of the detective aspect is not great but does its job.