I think it was Marlo Thomas in McMillan and Wife?? with Rock Hudson??
My daughter has had a Sleep Number bed for about 4 years and is very satisfied.
I have never owned a Sleep Number or Tempurpedic, but have sampled both. Sleep Number beds feel quite similar to a good traditional mattress. Tempurpedic beds feel entirely different--you would have to take them on a leap of faith with a return privilege or have some way of sampling one for weeks.
I seriously considered a Sleep Number, but balked due to the moving parts issue--they are basically an air bag with a pump, both of which are mechanical devices subject to failure. They do offer a return privilege, but as of a couple of years ago the purchaser had to pay return freight, which would be $100 or so. But they are very comfortable for my taste and would seem to be very easy to transport or move around.
Take a look at latex mattresses. A mattress expert on this forum highly recommended them 2 or 3 years ago when I was mattress shopping. They have a lot of advantages, last a long time, and feel great. Not sure, but they might be quite heavy?
I never made a new mattress purchase and am still gritting my teeth on a traditional mattress now over 15 years old.