Before LSD, magic mushrooms and MDMA were street drugs they were seen as one of the most exciting things in psychiatry.