While I cannot speak directly to global trends as I have not been keeping up with statutes and case law globally, in the United States alcohol intoxication is nearly universally prohibited as an insanity defense. Many states which use the ALI (American Law Institute) language for their criminal responsibility statute have wording in their statute which specifically prohibits the use of intoxication as an insanity defense. Settled insanity (the results of long term substance use) are often usable but intoxication itself rarely is from an insanity standpoint. It may be still be used as a mitigating circumstance, reducing sentencing, however.
While I cannot speak directly to global trends as I have not been keeping up with statutes and case law globally, in the United States alcohol intoxication is nearly universally prohibited as an insanity defense. Many states which use the ALI (American Law Institute) language for their criminal responsibility statute have wording in their statute which specifically prohibits the use of intoxication as an insanity defense. Settled insanity (the results of long term substance use) are often usable but intoxication itself rarely is from an insanity standpoint. It may be still be used as a mitigating circumstance, reducing sentencing, however.