I have a super memory pillow I got cause I thought I would like it. Turns out it's way too high for me to sleep on my stomach. So I have a super flat pillow and then use the memory one for my back at night. Just keep two stacked on the bed. And if I wake up and need to side sleep, I can just yank that pillow up and swap at night.

I'm sure there's no one pillow that's great for multiple sleeping positions, because I roll around in my sleep (sometimes becoming a literal burrito in the sheets), and having a couple different pillows has helped so I can grab whichever one Im feeling the most that night.