Ah, I think I'm in the midst of switching gyms. I currently belong to a tiny little weightlifter's gym, the membership is 'free' with personal training. It's totally tiny, no locker room, no extras, the 3 cardio machines are always used by people circuit training, using that gym both for weights and cardio would be out. So I use that place for weights.
I also have a membership to the YMCA. I personally don't care for it. There isn't enough equipment for the amount of members, there's hardly any variety of equipment, it's always overcrowded and there's a 30 minute limit on the cardio equipment. Which is a bummer - cardio is the reason I go there. I LOVE the concept of the Y, and agree that it supports the community. It's just not meeting my expectations. All are different. It would be great for someone interested in classes or swimming, I'm not into the classes offered and the pool is always way too crowded. We do like it for the monthly family night, my husband and son always attend. I trust the childcare center fully. Towels are provided, which is nice, not all gyms do that.
I just looked at another gym today, got a free 30 day trial, just a local private gym. Beautiful, honking big, clean! Tons of equipment, TONS, a large variety of equipment, great free classes - I'm actually interested in one, first time in my life - cardio tennis, how cool is that? 7 indoor tennis courts and strangely enough, I love the locker room. I could live there - a masseuse, whirlpool, steamroom, sauna - all in the freaking locker room. I could forget to workout.

Even stranger, there's a staffed bar by the pool. I could have a martini chilling by the pool. So many non-exercise diversions - my husband will kill me for spending more time at the gym. Same cost as the Y. My sister belongs there and told me she's never seen it busy, which is great cause I'm antisocial when working out.
I'd TOTALLY go gym hopping and coast for a few weeks on free trial memberships. Make sure you try them at typical peak hours if that matters to you. Be careful, some will call and pester incessantly once your trial runs out. Pushy sales suck.