The explanation I saw in a lecture was that when one of the vibrational modes of a complex molecule (H2O, CO2, CH4 etc) is excited, this creates an asymmetry in the structure, and this creates an asymmetry in electric charge - in other words a dipole. This is not the case for diatomic...