I have a moral duty to warn against this particular danger, because I do not want anyone to experience such a situation. And yes, it is real even though it is not common.
Here is an example of what I mean:
"This — the psychosis followed by the deep depression — was something completely different. And it was triggered by her use of psychedelics.
Eight months earlier, the woman had tried hallucinogenic mushrooms for the first time with friends and had such a great time that she took them again the next day. The second time, though, something went terribly wrong.
“She had a full blown psychotic episode for the first time in her life,” said Dr. Nemeroff, who published the woman’s story as a case report in The American Journal of Psychiatry in December. Her friends, who took the same drugs she did both days, had no lasting ill effects."
Source: Psychedelics Are a Promising Therapy, but They Can Be Dangerous for Some - The New York Times