If you hate foam as much as I do, you can't go wrong with an Ikea spring mattress. I've had people ask about what kind of guest bed they slept in because it was so comfy for them. Ours is the firm one, and the guest room has medium firm.
https://www.ikea.com/ca/en/p/haugesu...07295/#content