Best affordable mattress: which one should I buy?

My old mattress has finally given up on me—I’ve been waking up sore, and it’s definitely time for a replacement. The problem is, I don’t want to spend a fortune but still want something comfortable and supportive.

What do you think is the best affordable mattress right now? Any advice from your own experience would be super helpful—thanks!