Games

I personally enjoy Brok the Investigator, if you don't mind beat-em-up mixed in with your story. Has multiple endings, every single area has 3 hidden collectables that act as hints in case you get stuck, and is available on console (ps4/5, xbox one and series s/x, switch) if you don't feel like playing on PC.

You play the first chapter as a detective alligator (Brok) who has a new case to solve. Starting chapter 2, you gain access to switch between him and his cat son (Graff). Depending on your actions, you get the different endings. To make things easier on getting different endings, you can load yourself in at specific chapters, too.

NORCO is the best old-school point and click adventure I played recently. Great pixel art. Great writing.

I really recommend Stray, it was a a classic feeling adventure game to me when I played and I quite enjoyed it.

Another vote for Disco Elysium. For an old-school classic dripping in atmosphere, check out the 1997 Blade Runner PC game.

Legend Entertainment produced some great adventure games throughout the '90s. The wiki article has a list of them, and several are available from GOG.

Have you tried Resonance? It's a mystery adventure game set in modern times where you play as four different characters whose stories interconnect. It's been a while since I played it (a decade or so?) but I remember that it had an interesting game mechanic that let you use memories like items in various interactions, as well as a number of puzzles that I rather liked the design of.