When I was in Boston I worked out at Boston Sports Club, which I really liked. I thought it was worth the money, the equipment was great, and everyone was pretty helpful.
Here in CT I'll probably join Gold's this summer; I didn't like the Boston one too much, but the CT ones I have worked out at have been much better.