Firm mattresses are supportive, so they're a great option for older adults with issues like arthritis. But there's such a thing as too much support. A mattress that's too hard may dig into your joints, causing uncomfortable pressure points.
Ultimately, personal preference and comfort are what matter most.