I have realized over the years that I need to be seriously cold to sleep well. My health watch always registers a great sleep and recharged "body battery" when I've been almost shivering all night. My partner likes to joke that my body needs "suffering to get fully rested".
These days, I only ever have nightmares when I'm too hot. It's a challenge to stay cool enough to not get them.
I did recently switch mattresses to this Airweave Futon: https://airweave.com/products/futon
It's an amazing product, it helps keep me cool, and is nice and firm, which I need to have a restful sleep without back pain. By far my favorite mattress I've ever used.
The Airweave has reduced my hot nights significantly, and I'm thinking if I can put a cool pad underneath it, I'll be set!
I'm going to have to try this DIY project for sure now!