I played an absolutely unhealthy amount of Broken Sword 2 when I was a kid. I still remember the bullshit reasons I used to convince my mom to buy it for me after seeing the cool box at the local game store. Something about how it would actually be really educational for me. I think it was more "fine, just shut the fuck up" than it having been a really convincing argument. Blade Runner was another one I put a lot of hours into.

Some fairly recent ones I've really enjoyed and would recommend are Gemini Rue, Resonance and A New Beginning.

Some favorites of mine that often goes overlooked are some of the Dynamix games, which were a subsidiary of Sierra for a little bit "grittier" games, including fighter pilot/war titles and Betrayal at Krondor.

One of my faves was Rise of the Dragon, a Blade-Runner/Shadowrun-esque adventure game set in a dystopian future, where you played a former police officer turned private detective out to solve a murder of a young girl from a dangerous drug.

It had a ton of reactivity and options in how to pursue things, with multiple endings and ways to get to the finish line. If you get the chance to play this game (I believe it is freeware at this point), I'd highly recommend it. The graphics hold up really well, the story is intriguing and, as stated, the paths you can take to finish the game are quite numerous.

I never played that one. But I did play Heart of China. Much the same gameplay, I think?

Yes and no? Point and click adventure game fair plus some action sequences, but I found the non-linear nature of RotD to be much more enjoyable than Heart of China. I replayed Rise about 18 months ago and it holds up really well, but doesn't take all that long either, so I'd recommend spending a few nights on it as a high priority for any adventure game fans.

Quest for Glory series is my favourite.  Great blend of RPG/Adventure with some puzzles having multiple solutions and having expansive character stat customization with 3 character classes (with a fourth unlock-able depending on your actions).  Also a great sense of humour and you can export characters to the later games.

Heart of China was very very linear, yes.

Full Throttle. God, great times. I need to go back and play that and The Dig again sometime.

It was a really good one. Unintentionally hard because of one or two poorly designed puzzles (that damn fossil/life crystal one drove me INSANE), but very interesting story and world to explore.