I only occasionally get night sweats but I have métis sheets which are great. Métis is a heavyweight cotton/linen mix, formerly very popular in France and Belgium, usually only available or affordable secondhand. I snap them up when I see them (which is not that often). Also great for very hot and humid summer nights.
They're usually monogrammed in elaborate embroidery, possibly to identify them as stuff was sent off to the laundry back then. The embroidery is helpful in dating them. I've got one with lurid embroidered roses that screams 1950s but the best one I have looks Edwardian.
I don't take HRT or anything. This is mainly because in the 1970s I was on the pill and had a dreadful time on it so that put me off any hormonal prescription stuff for life.