It really depends on your personal preferences - to you get up a lot at night? Then probably foam won't be the best solution, as it makes you sink in. Do you like it in medium firmness? Then latex with foam topper will do. Are you a stomach sleeper? Then firmer is better. In a nutshell - try to sleep on foam at least once, as people's reviews tend to be versatile (in generally, most do like foam memory mattress, but it has its own specifications). Maybe a latex with a foam topper?
I think that a foam topper might be a great solution for those who don't generally like memory foam mattresses for whatever reason. Toppers are good because they can be replaced, removed, they provide a different feel to the mattress. Also, if the mattress is too firm, a soft natural topper (from natural fur, for example) can make a huge difference. It's not just a workaround solution, in my opinion, it's also a quality item to add to your bed (and think if you have guests, for instance, who hate firm mattresses, this could also be a solution).
At the time, long time ago when I was going through my vast mattress research, I used whymattress website which provides not only major mattresses and topper categories, but also special subcategories such as: what type of sleeper you are (side sleeper or stomach sleeper, for example), what mattress is recommended for highly weighted people (yes, I hate that subject, but there is no escape from that, we must consider our weight), and other different parameters. For stomach sleepers, for examples, a firm topper could solve the problem of mattress being too soft, as it is generally recommended a firmer mattress for stomach sleepers. So, here it is, hope the link won't be banned, it's really useful whymattress.com/