Which substance, when abused during pregnancy, is the most significant cause of cognitive impairment and dysfunction in the infant?