I played Dreamhold years ago, one of the first games I've played, and it's never been quite my favorite. It is intended as being accessible for beginners but still fun for older players. It is a mid-length fantasy game, where you play as a wizard trying to reconstruct his memories in a tower.
The puzzles are of course top-notch, especially with the berries and the stars. However, the plot was never really compelling to me. The protagonist is not an underdog, and everyone likes to root for the under dog.
Actually, I know exactly how to describe this game. This is Citizen Kane for interactive fiction. Reviewing the life of an old, powerful man and seeing how he got there. If you liked Citizen Kane, you will like Dreamhold. If you don't really go for those kinds of characters, you still might like the puzzles quite a bit. For me, it's the kind of game that I love while playing, then forget when I'm done.