prog definitely helps with sleep for most folks

I have to take my prog rectally, it turns out the liver filters out most of it when taken orally and you get very little increase in blood levels as a result (read more here), so you might consider trying 100 - 200 mg rectally and see if that helps the sleep issue for you. Personally I find oral is less effective for my sleep than rectal administration, but that varies significantly from person to person.

Night sweats and brain fog screams low estrogen, though - I would have tried increasing estrogen for those symptoms, not progesterone. Maybe see if you could get a cream that would allow you some flexibility in dose timing and amount, then once you know what works you would know a better long term stable dose for your patches. Sometimes low enough estrogen can cause sleep problems too, so it may not be a problem solved by taking more prog if you just need a bit more estrogen.

I'm so sorry you're going through this, but I'm also happy you're staying invested in finding a solution and not just trying to tough it out 💖