Games

I enjoyed Botanicula. It's a cute point-and-click adventure game.

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.

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.

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

Oh! Can’t believe I forgot, but you should also play Under a Killing Moon, and then when you’re done and completely in love with it, move on to The Pandora Directive, Tex Murphy: Overseer, and Tesla Effect. They’re a series of hilarious retro-sci-fi gumshoe detective comedy puzzle adventures. It’s like Maltese Falcon, Blade Runner, the X-Files, and Young Frankenstein got put in a blender. They’re amazing.

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