Legend Entertainment produced some great adventure games throughout the '90s. The wiki article has a list of them, and several are available from GOG.
Atari tried to do this in the '80s, but it never went anywhere.
Yup. As I recall it was kind of a school-wide effort, with kids relaying solutions of various puzzles to each other until we had enough to complete the game. I do recall working out the Babelfish puzzle on my own, though I also neglected to feed the dog at the beginning of the game soft-locking myself on at least one playthrough.
every game on their [sic] I can find on Steam
Oh yeah? Find these:
3 out of 10
A Knight’s Quest
Alan Wake Remastered
Alan Wake 2
Assassin’s Creed Mirage
Battle Breakers
Binary Smoke
Castle Storm 2
Core
Corruption 2029
Crime Boss: Rockay City
Dangerous Driving
Dauntless
Dead Island 2
Diabotical
Ghostbusters: Spirits Unleashed
Goat Simulator 3
Grit
Infinitesimals
John Carpenter’s Toxic Commando
Kid A Mnesia Exhibition
Kingdom Hearts series
The Lord of the Rings: Return to Moria
Ooblets
PC Building Simulator 2
ReadySet Heroes
Rocket League
RollerCoaster Tycoon Adventures
Salt and Sacrifice
Saturnalia
The Settlers: New Allies
Shoulders of Giants
Sins of a Solar Empire II
Space Punks
Star Trek: Resurgence
Tchia
The Crew Motorfest
The Expanse: A Telltale Series
Tortuga - A Pirate’s Tale
Touch Type Tale
Witchfire
The Wolf Among Us 2

Josh Strife Hayes just did a video on classic Everquest:

Kiss did something similar with a comic book back in the '70s.

This kind of thing has been going on for at least 30 years. One of the earliest examples is Night Trap starring Dana Plato. You may not know who that is, but anyone who grew up watching Diff’rent Strokes certainly does. If you want a more mainstream example, look at Ripper from 1996 which features Christopher Walken, Paul Giamatti, Karen Allen, Burgess Meredith, David Patrick Kelly, Ossie Davis, and John Rhys-Davies.
You can get the 1997 Blade Runner game from GOG.com which has been updated for modern OSes. It looks like there was also a remaster done a year or so ago, but based on the user rating you’re probably better off with the non-remaster.
Well, so much for Yuzu. Wonder how long Ryujinx will last?