Since some of your symptoms and issues with hrt sound very similar to mine, I’m going to share my story so far. Your issues might turn out to be totally different or you might see some helpful things.
So, for me, the insomnia in the week before my period, started in my early 40’s and this went from only the week before my period (when estrogen is low) to all the time at about 48. I had some hot flushes during the day too, but those were pretty mild (during the night too, but very very disruptive to my sleep) and then there came dizzyness. I’ve been trying to get my hrt right for almost 2 years now, but I soon realized estrogen was the answer for me. Progesterone (utrogestan) was the devil (I’m intolerant, I’ve tried continuous, sequential, vaginal, everything), but I now have good hopes I’ve found a progestin I’m tolerating.
The estrogen part is however tricky for me too. I find that with oral estrogen I get way too many fluctuations, I seem to metabolize oral estradiol really fast, giving me spikes (and nausea and a jittery feeling) a few hours later and drops (and hotflashes) after about 8-10 hours. Patches gave me a rash, but also were very uneven for me, I was nauseous and jittery for the first day, then I had 1 goid day and then low estrogen symptoms again. I’ve been on lenzetto and split my dose to around 7 am and 7 pm and that felt very even, but was a bit low towards the end. I’m now on oestrogel (for 2 weeks) and also split my dosage and it also feels very even. Hot flushes are gone, I’m still slightly dizzy and not sleeping the best, so maybe going higher with my estrogen will turn out to be better, but I’ll wait until my next appointment with that (I went one pump higher than my prescription already).
Another piece of the puzzle for me was suppressing my cycle btw, progesterone doesn’t do that and not all progestins do either. My cycle was getting worse each month lately and now that it’s suppressed, I feel way more balanced (even though I have annoying side effects right now from starting a new progestin).