Alcohol can't give you psychosis after taking it only one time (or it is at least far less likely. It also can't give you persistent hallucinations[1] or permanently change your personality[2]. (In most cases these changes may appear positive, but there is probably potential for negative personality changes, too.)
[1]: https://slatestarcodex.com/2019/09/11/lots-of-people-going-a...
[2]: https://link.springer.com/article/10.1007/s00213-017-4733-3