Queen bed recommendations for couples? Partner runs hot and I need support - tough combo

Hello! My partner and I are replacing our old queen mattress after moving into a new apartment. I’d love to hear some advice from anyone here living with their partner on how you decided to buy a mattress when you have different needs/preferences. My partner runs hot all night while I can’t live without a comforter. I also sit at my desk job for hours everyday so I usually feel some lower back stiffness at the end of the day so I’d much like a mattress that can help me feel relieved of the pain and recover well for the next day.

We’re getting a queen (think that’s just enough space for both of us) and we’re hoping to stay in the $1500 range. Suggestions anyone?