Alcohol poses a significant amount of personal and societal risk, followed by drugs like heroin and cocaine, while psilocybin is at the opposite end of the spectrum, having relatively low risks despite not being recognized culturally as a drug.