What Makes a GREAT D&D Adventure?

We've all run bad adventures, whether out of a book or ones we made ourselves. But how do we go about making memorable, exciting, and engaging ones? And how do we, as players, help to make the adventures great? Lets discuss!