In answer to your question, yes, I have had success with HRT despite a family history of stroke at an early age and despite having had migraines with aura.
Having spent (wasted) two years of my life, aged 40, with debilitating back/leg pain, tingling, nausea, crushing fatigue and dizziness (none of the normal signs, so it was only a blood tests that indicated hormonal issues) the doctors agreed that - weighing up the risks - HRT was still more advantageous to me than not taking it. I had reached the point where I really couldn't cope any more, was at risk of having to give up a much loved career and really was a mess.
I wont lie. I hated the idea of HRT at first and tried everything from vitamins and minerals, to ADs, to expensive osteopathy, but nothing helped. I started on a very low dose, with bio identical progesterone and had the warning signs of DVT clearly spelt out to me. Later, I switched to a bio identical birth control pill in order to fully suppress my ovulation. (I am not allowed anything stronger than this new pill). It took several months to kick in, but was worth it, for sure. I now have some form of quality of life back.
Interestingly, fingers crossed, since being on Qlaira (and not ovulating) I have not had a migraine.
It's different for everyone and like I say, it wasn't a decision I took lightly, but I'd reached the point that I had to do something and HRT was by then my only option.
I hope you find something that gives you peace, whatever that might be x