How Far are We From Generating Missing Modalities With Foundation Models?