The better options and possibilities I’m aware of in and around the Detroit region (subject to the guidelines here) are listed in post #2 here.
There is more about the pros and cons of memory foam vs latex in post #6 here but in the end this will come down to a preference choice based on which types of material (or combinations of material) and mattresses your testing indicates you tend to prefer.