Comfy Bed Recommendations

My husband has bone cancer and we are looking to purchase a new bed for better comfort for him and also me. As he often wakes in the night which then wakes me.

Can anyone recommend a bed which they have purchased which is comfy for the patient. His aches are in both hips, rib cage and spine.

Open to suggestions which also may be of value to assist in a better nights sleep. Thanks Team