I've never felt uncomfortable in the free weights section, and I am never in the cardio machine section so I've no idea how the men behave over there. They do pay attention in the free weights area though, but in a non-creepy way. I am quite short, and when I am struggling to pull that 25 pound weight off the top of the plate rack (I can barely touch the plates up there), within a few seconds some nice tall(er) helpful person shows up to help out - generally male. I've had a few positive comments about how hard I work but that is it.
Pebbles67, it would be good to have someone eyeball your squat technique. Even with videos it can be challenging to know what our body is actually doing rather than what we THINK it is doing. It took some time for my trainer to bash into my head about NOT leading with my knees - the problem was it didn't FEEL like I was doing that. You probably won't have the same problem but I wanted to mention it. A proper squat is the foundation for so many movements and you can cause yourself some problems if it isn't done properly. Is there knowledgeable staff at your gym that you can trust to give you good advice on your form? Not all gyms have this, sadly.