I'm going to say Hokus Pokus Pink. It's not the greatest adventure game ever made, and its puzzles are fairly simplistic if I recall, being aimed at a younger audience. But it's got a certain weird charm to it. It's compellingly bizarre!
The writing is surprisingly good too, and the Pink Panther and his utter cluelessness about what's going on makes for a fun protagonist.
Adventure / Point-and-Click / Narrative Games
A community for fans, devs, and general aficionados of the adventure game genre. This includes IF/parser games, point-and-click games, puzzle games, walking simulators, and whatever else you want to call these. To us, they're simply adventure games.
Discworld...the game is hard, confusing, and sprawling, but so much enthusiasm went into the animations, voicework, and design.
Also: Gobliiins series. In a class of its own, highly inventive and sui generis French design that is often overlooked for being so oddball.
In response to the OP: I love Loom in principle but I've barely played it. Really need time to get into it. Hopefully the SteamDeck will let me do that at some point.
But yeah, memorized tunes functioning as the verb interface, and physical looms that weave existential magic? I'm into that.
Wadjet Eye Games's The Shivah (old enough to be a classic at this point! But still pretty obscure and underrated.)
I think a lot of adventure game fans have heard of it but Callahan's Crosstime Saloon is pretty great and it's my favorite game designed by Josh Mandel. I really wish it could get a digital rerelease.
A lot of people really hold this one in very high regard. Unfortunately, with regards to a rerelease, the rights situation is a tangled spiderweb of immense proportions.