A trainer that is not testosterone-poisoned (or mimicking the testosterone-poisoned) is worth their weight in gold. I was fortunate enough to have such a trainer (former student of mine) and he was lovely, working with me on my goals and desired outcomes instead of screaming at me to "motivate" me. I suspect you'd get more such trainers at a women-focused gym, since it seems to be a mostly masculine trait for people to want to be screamed at incoherently as motivation.

But…

One such gym that I tried had only perfunctory weights, mostly machines, and a whole lot of cardio; I was hell-bent on lifting and strength training, so it was not a good match for me. The only cardio I can tolerate is cycling. (The real thing, not those stationary bikes.) I go to the gym to use equipment I can't use at home (like 90kg of weights for squats and dead lifts) to boost my strength and muscular health. Cardio I don't need a gym for. You should probably scope out the gym and make sure that it has the equipment and space you need for your priorities.