Shopping for a mattress is a major PITA. We did it not too long ago. Here are some thoughts and opinions.
Avoid the "sales" at department stores. They never have the low priced ones they advertise. I wouldn't buy a cheap one anyway. The mattresses they sell at Costco are very reasonably priced and might work for you but in general, they're not the best models. Wherever you shop, consider a floor model. They really don't get worn out being on display and you might save some bucks. I mention this because we got a deal on a floor model but when the set was delivered it was a brand new set! It was tightly wrapped in plastic and I casually asked the driver whether they picked up the mattress at the store and he told me that just came from the warehouse where they picked up the set.

Sales guys will give you all the lines but most of the lines are true. For example: "You wouldn't hesitate to spend a few thousand on a stereo or television but will either one make your back feel better or give you a better nights sleep?" True. Don't cheap out. I had hoped to spend much less than I did but when it comes to your health, comfort, and sleep you should be willing to spend.
We wound up buying a fantastic mattress that's made of various types of foam with a couple of inches of memory foam on top. It's basically a solid mattress so there is no air inside to trap dust and mites that cause allergies. It's solid and not like the Tempurpedic beds that are kind of like sleeping in a mold. One great feature is that motion is very isolated so you cannot feel it when someone gets in bed while you're sleeping. (Okay, maybe that's not a good thing.) We've tested it by lying down and the other person literally flops on the bed and other than the movement of the bed frame itself, there is no trampoline effect. It's just "thud". It's either a Simmons or a Sealy. The only tag on it reads "Chiro Pedic" and "Dana Point Elite". We love it and couldn't imagine going back to a spring mattress.
To answer your last post, I think all major brands make good stuff and crap. It just depends on the price point. Go test out some and you'll find it's much like Goldilocks: You'll just know which bed is the most comfortable.