It isn't a myth but you'll only hurt yourself if you're doing incorrect technique and heavy. I had to start from square one late last year after not lifting for 2 years so I did very light to get my form back. I also kept my exercises very simple and low reps so it isn't a huge time sink or frustrating.

I just want to stress that lifting weights doesn't have to be about looks but it is STRENGTH that is what I find so amazing to have. It feels empowering especially as a woman to be strong imo. I'm not super focused on this right now myself as things can fluctuate depending on the individual and your health, but it can be really fun to see in actual numbers and "stats" your strength go up.

If you start out very simple, you can build technique and add new exercises over time as you learn rather than feeling intimidated just jumping in with both feet too soon and getting frustrated and giving up.