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 this may be true in a broad sense - one may need to take into account neurological diseases such as dementia or FTD (frontotemporal dementia) which may increase impulsivity and strikes at the very heart of executive decision making networks within the brain.
Diseases such as FTD may influence stealing, gambling addiction etc
For a good analysis and examples of criminal behaviour in patients with FTD and Alzheimer's see: Liljegren, M. Nasaan, G. Temlett, J. (2015) 'Criminal Behavior in Frontotemporal Dementia and Alzheimer Disease'.
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.
Being intoxicated does not excuse committing a criminal offense