If you want minimal to zero motion transfer, you should try memory foam mattresses because they tend to absorb movements and limit motion transfer so you won’t be disturbed even if your partner tosses and turns in bed.
While mattresses with better motion isolation can be less responsive than their counterparts, you get the advantage of getting a good night’s sleep because they minimize motion transfer.