What Makes an Adventure Awesome?

Some adventures like Keep on the Borderlands or the Village of Hommlettare classics. Other adventures are somewhat less good.

But what makes an adventure awesome? What gives it that spark that lives forever in a player's memory?

Let Raging Swan Press know, in the comments below.