Considering progesterone for sleep, what has been your experience?

Long story short, Im 47, still have cycle, every 3 weeks. I've experienced chest night sweats everyday for years. Im on vagifem ( suppository) 2x a week and bonafide for dryness, it has helped so much!! But now, the more I look into it im more curious. I can't sleep, I wake up almost every night, hard time falling asleep, weight gain ( not by lack of health style) I just feel tired all the time. Can progesterone help me for sleep and overall wellness?? What has been your experience?? I just get scared with all these talks about how hormones can give you cancer. ( My sister got breast cancer) not from this but in general, im just concerned.