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.
NORCO is the best old-school point and click adventure I played recently. Great pixel art. Great writing.
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.
Welcome to the largest gaming community on Lemmy! Discussion for all kinds of games. Video games, tabletop games, card games etc.
Submissions have to be related to games
No bigotry or harassment, be civil
No excessive self-promotion
Stay on-topic; no memes, funny videos, giveaways, reposts, or low-effort posts
Mark Spoilers and NSFW
No linking to piracy
More information about the community rules can be found here.