Don't really have a preference since I won't be sleeping on it but for that price I'll definitely take a look at it.
We bought the Costco Novafirm queen for our guest room a few years ago. It's highly rated on Consumer Reports. I like it. Sometimes I sleep better on it than our Tempurpedic.
We bought a Novaform from Costco. I liked it for about 2-3 years then it began to get way too squishy. Good for the price, but the shelf life is pretty bad. It's a great guest bed, however.
If you're getting it for a guest room don't overthink it. Your guests won't stay long enough to notice any problems. Just focus on a brand that doesn't have terrible ratings, and a seller that can deliver to your room of choice and/or take away your old mattress if you have one. Wait for a decent sale then pull the trigger.
The Costco memory-foam mattresses are pretty underwhelming for the price. Do your own research. The one I linked is good for teenagers and guests. And it comes in a box. Not sure about removal services, it seems weird to me since I can just push the old one out to the curb on trash day.