A lot of classic graphic adventure games were exclusive to computers. If you want to call them "walk and talk games" or even "Aaron Sorkin-like games," be my guest.
I'll mention a few which had console adaptations...
*
Snatcher and
Policenauts were mostly released on consoles. Both were Konami titles with a lot of credit given to Hideo Kojima. The former game had a single official English edition, which was available on Sega CD for only a few years. The latter game has fan translations available for the Playstation 1 and the Sega Saturn versions.
*
Rise of the Dragon started on late '80s computers, and had a Sega CD port. At this time, one of the computer versions is still on print through GOG.
* The MacVenture games all have console ports.
Uninvited is probably the best choice if you want a downbeat game, since it's a haunted house story. Original
Shadowgate and the two
Deja Vu games both have unnerving aspects. If you liked the NES or Gameboy Color ports of
Shadowgate and want more, then look for the recent remake of
Beyond Shadowgate.
The Dig, a 1995 LucasArts game, has only been released on Windows, Mac, and Linux. If you need a dreary adventure game, then it's currently available on GOG and Steam.
A handful of goofy, mild adventure games worth mentioning...
*
Maniac Mansion had a NES port. It took decades, but the follow-up game
Day of the Tentacle received a remake available on PS4, Vita, and Xbox systems.
* The Adventures of Willy Beamish is a cartoon adventure game which had a Sega CD version.
* There were two
Discworld games in the 1990s, based on the Terry Pratchett books. The first one started on DOS and Mac, and got ported to Saturn and PS1. As far as I can tell, the sequel was exclusive to those two consoles.
