Sleeping on a cloud is not comfortable

I recently had to stay at a hotel for 2 weeks and the bed was huge! It was like one of those memory foam ones that are super super soft, the type of bed that everyone says in YouTube videos that they make you never want to get up. And I have to say... it was not for me. Yes, it was nice at first but it's just too soft to the point where I felt like I was sinking into the bed and had absolutely no support at all. I woke up with back pain almost every morning and missed my own bed which is just a normal innerspring mattress with a 2 inch topper.