I'm assuming you mean long-term sufferer, not criminally insane, and magic potion cured in the blink of an eye. That's not been done.
Doesn't Barclay count? Also there was Lon Suder on Voyager. I realize that Jayson was probably looking for something deeper than those examples.
Edit, yeah Suder was criminally insane I totally missed that sorry.