Yes, but with caveats. If you go to a big mattress store and buy from the big brands (Sealy, Simmons, Serta, etc.) you are getting a mattress that is cheaply built at a high price due to shitty private equity firms buying up the brands and squeezing every bit of value from them.

I ended up spending a fair bit ($2600 but the "equivalent" at the major chain store was $3400) on a locally manufactured mattress with more expensive materials like latex foam and wool but only after I tried a bunch and found one that kept me nice and aligned. Immediately I stopped waking up with the type of pain that would stay with me all day (I would be slightly stiff for 15 minutes instead), and now that my body is used to it I only very rarely wake up in pain.

The big thing is to find somewhere without shitty sales tactics, and to try a bunch of mattresses out and find out what works for you. I didn't like the memory foam mattresses, but some people love them. There is a reason why they make firm, medium, and soft mattresses. There are mattresses where the springs are the same all over, or vary based on where people keep their body weight.