my scope is admittedly narrow, but here’s what i know:
i belonged to both the YMCA and YWCA for extended periods of time over the last 20 years and now go to one to which i get free access where i work, so my observations may not be most current ... i didn’t try the private ones because my primary interest was lap swimming and they didn’t have adequate facilities ...
i found the YM to be the more expensive, more crowded and more frustrating to deal with “problems” that might arise. as i am mostly a swimmer and walker, i can’t judge the weight machines, but was attracted to the YM’s TWO pools ... one cooler, one warmer. one drawback to using the warmer pool was that it was used for family swims in the evenings and was not carefully cleaned afterwards. on more than one occasion, i was greeted with floating feces in my wee-hours-in-the-AM swim (i typically was there when they opened, on a daily basis). they DID provide towels, which was a major bonus as i didn’t like hauling wet towels back and forth on a daily basis. the sauna and hot tub were nice, but usually in use and i didn’t have time in my routine to enjoy them, so maybe that’s a moot point.
the YW (where i last belonged until transferring out 3 yrs ago) was much cleaner, more modern (it had been recently updated when i first joined) and has a more supportable mission for my taste. the cost was less, the pool was smaller but i ALWAYS got a lane and i used the treadmill/ellipticals and never had to wait for one, which was important because i like to work out in the mornings before work and my schedule was pared down to the minute. at that time, no sauna or hot tub, but i didn’t miss them.
hope this helps ... you might want to check out any college or university close by to see if they allow community memberships. i now attend a university gym and it far exceeds any private or Y gym i’ve ever seen, complete with climbing wall, indoor track, extensive equipment, classes, etc.
also, check with your employers and/or health insurance companies, as you may get subsidies for joining any of your choice, or a particular one with which they have parternship as an employee benefit.