My single experience in a scary weights-only gym was getting told by some beefed up roider that I train like a (very rude word for vagina that I couldn’t find a good translation for). My current gym has a split of about 60:40 between weights and cardio in favor of weights and the atmosphere is so much nicer.