Spqce Quest 5 is the only one I go back to. It’s funny, has well-written and memorable characters (for Space Quest), there are few unwinnable situations, and the puzzles rely mostly on human rather than adventure game logic.
On the other hand, it feels like the studio ran out of money while making it. There’s a ton of planets in the game you never visit, it’s not a talkie even though the game before was, and one of the last things you do in the game is a huge trial-and-error maze that is 100% pure padding.