A lot of the bad press is around older forms of HRT. The newer, body identical HRT has far fewer 'issues'.
For me, HRT saved my life. No joke. I was suicidal.
However, it took 8 months to work. For some of my friends it was more or less instant, but for me it took a lot longer. For some of my friends it didn't work. One friend is unable to take it (medically).
My point is: it's a very imperfect science. You may need to try different types of HRT, different combinations, to get it right for you and your body. You may need to change dosages over time, as your hormone levels fluctuate (I recently upped my dose as previous symptoms began to reappear). You need to allow 3 months for each 'change' (to type or dosage) to take effect.
Don't be afraid to experiment to find out what works for you. Don't be afraid to request a new nurse or GP if they dismiss you or aren't educated enough about peri/menopause or aren't supportive.
Every woman and every woman's body is entirely different. You may find it works straight away or you might find it's awful and doesn't work at all - but, for me, the fear around being so unwell I wanted to end my life far outweighed my squeamishness about taking a scientifically tested and proven medication that for the vast majority of women is safe, and works.
Good luck, I know how hard it is x