Hi scurve,
The first place I would start your research is post #1 here which has all the basic information, steps, and guidelines that can help you learn how to make the best possible choices in terms of the suitability of your mattress and it’s quality/durability and value.
You are also fortunate to be in the San Francisco area because you have some great options that are certainly within your budget range and post #2 here has the better options and possibilities I’m aware of in the area.
You can also read more about hotel mattresses in post #3 here and the posts it links to and for the most part I would avoid them because of their lower quality and value.
Of course if you have questions or comments along the way they are always welcome 
Phoenix