For some three years, New York City venue became known as “the church of rock,” presenting some of music’s greatest acts