Can cosmological simulations capture the diverse satellite populations of observed Milky Way analogues?