How do you choose mattress firmness for back comfort?

I work with mattresses and often see people struggle with firmness choice. Many assume firmer is always better for the back, but in practice body weight and sleeping position matter more.

How did you choose your mattress, and did your opinion change after a few weeks of use?