Hi rdmelton,
In case you haven’t already read this … I would make sure that you have read post #1 here and the information it links to so that you are armed with the basic information you will need which along with your personal testing can help you make the best mattress decisions.
There are actually some good options in the Lafayette area which may be well worth exploring. The worst case is that they provide some good reference points for an online purchase and the best case is that they have the kind of quality, value, and service that fits your “personal value equation” even better than an online purchase with less risk of trying an unknown mattress. They are listed in post #2 here.
If you do decide to go in a memory foam direction then both Dreamfoam and Rocky Mountain Mattress are both great choices but of course each offers different mattresses and layer combinations and also different options in terms of re-arranging layers and exchange or return options. Talking to them about their options and which may fit your body type and sleeping positions best will certainly be one of the most important parts of making the best choice for you.
I would also caution you that with people who sleep in all positions … especially when it includes stomach sleeping … I would be very cautious about choosing a mattress where the comfort layers are any thicker or softer than you absolutely need to relieve pressure because there is a larger risk of alignment and back issues with layers that are too soft and thick to provide the kind of support you need in your 'riskier" sleeping positions. I would make sure that you had some good and “accurate” reference points from local testing before making your choice.
Hope this helps.
Phoenix