What makes a good membership site?

There are many different ways one can create a membership offering for their site. What makes a membership site memorable?