I’ve found memory foam can be really hit or miss depending on the bed.
Full memory foam like this one is nice, but I find it lacks support.
I don’t like polyfoam support.
With coils memory foam needs transition layers, which makes the bed vary widely.
I’ve found that it can work really well on latex.
I’m thinking of going latex for my next one, and maybe getting a memory foam topper. More about that here.