Insanity defense is a hard nut to crack. And has been notably unsuccessful in drug-induced psychosis. Or for that matter, any type of psychosis. And the differences between the UK and US aren't that major here.
Although there is some differences between hallucinations and delusions, I'm not going to get that technical here. Let's say someone thinks she's Ann Boleyn. There's absolutely no dispute about this fact. It won't do her a bit of good. Because neither Ann Boleyn nor any other person can act in an illegal fashion.
So let's say that while believing she's Ann Boleyn she decides someone is Henry VIII. And my guess is Henry VIII was rather an undesirable person to be married to. So instead of a divorce, she decides to kill the guy. Because she no longer wants to be married to Henry VIII. Everybody agrees this is what happened. No dispute about the diagnosis. But it doesn't help. Because Ann Boleyn has no legal right to off her husband instead of getting a divorce.
If, however, she believes she is Ann Boleyn, she decides someone is Henry VIII, who is going to execute her, and acting in self-defense to prevent that execution, she kills the Henry VIII, at a time where she does not have a duty to retreat, or can show that a duty to retreat does not apply. At this point, she has a defense.
In other words, if a person has a delusion or a hallucination but is able to determine what is right or wrong, the delusion or hallucination only works if the person acts in accordance with legal standards.
OR
The person has no understanding of the difference between right and wrong, or lawful and unlawful, or good and bad. The classic example is that the person would have done the same act if the person had a police officer standing right next to them. Understand this is a very hard thing to convince anyone of. Or in other words, the person has absolutely no understanding of their actions.
Drug-induced delusions and hallucinations rarely rise to this level. Classic negation of this would be the person saying something like, "Cool it, it's the cops." And think how many drug-induced people have a reaction to seeing the cops or fearing the cops, even though they are having delusions or hallucinations.
Combined with this is the tox screen that's going to be needed to show the person was under the influence of a drug. If the drug shows up as a typical drug which people take for the purposes of causing psychiatric effects, people are going to assume the person took the drug voluntarily and intended to have that result. In other words, drinking to forget. Drinking to forget can limit the ability to form some mens reas (state of mind), but leaves a wide variety of lesser charges that the person can face.
If you're going for realistic, it's hard to find a drug that's going to meet your requirements to present a defense in a courtroom. More likely, the government is going to want to deny that such a drug existed, and never bring the case.
Best of luck,
Jim Clark-Dawe