LSD and Mushrooms can be an effective treatment for cluster headaches (a debilitating disease which is said to be "The most painful medical condition known to science").
http://en.wikipedia.org/wiki/Cluster_headache
Interestingly, the effect lasts for weeks after the dose is taken (and the hallucinatory effects have worn off).