Nah, even blind drunk, I've been able to write bulletproof, complicated code. Stuff that checks out the next day as perfectly fine - furthermore, stuff that I can remember the entire thought process behind. It differs from person to person; some people simply can't think or remember clearly at all when drunk, some other people have a "Ballmer Peak"
https://xkcd.com/323/ - I'm not sure why, but I think it might have to do with mild amounts of alcohol relaxing their mental processes and helping them get over certain mental hangups that trip them up, normally. Other people have a Ballmer Plateau, where the alcohol allows them to enter a meditative state of complete and utter mental focus, allowing them to be fully lost in their work, and to work at 100% capacity as long as the buzz lasts. Sort of a working "trance", if you will, freeing them from all procrastination.
I suspect this is a large part of the allure for many ADHD-types; the freedom from procrastination is something they're afraid they can't otherwise achieve.
I know this sort of thing is the case in a lot of fields which require similar "non-procrastinative focus for hours on end". Writers, artists, animators, musicians - all of these have tons of people who struggle to knuckle down and put in long hours without a buzz going. Stephen King talked about this a lot in his autobiography - I could quote a lot of other anecdotes from other people, but his really had a personal effect on me.
-
I struggled with this myself (I drank for maybe 6 years in/after college, and I drank pretty hard for a few of them). It sucks because I can't recommend anything to help anyone; what worked for me was not "actionable".
What cracked it for me was when the enjoyment lost its edge; over time it just got harder and harder to hit that 'sweet spot' of the perfect alcohol buzz, and the hangovers got crummier and crummier. Finally just ... deep down, subconsciously, I was gut-reacting to the prospect of a drink with more anxiety than anticipation. That was the end; I just lost the will to try, from too much associative-emotions of pain and fatigue investing themselves in the idea of drinking. Just like that. I didn't even have to go cold-turkey; I have a drink every few months, and even just a couple drinks leaves me feeling just "crummy" enough the next day that this emotional association won't go away, and it seems to have quieted (almost) all the urges to drink I used to have. I have no fear, whatsoever, of falling off the wagon because when I do drink, I no longer feel that unstoppable compulsion to take my buzz even higher - that alone was the element that made me an alcoholic, and it's gone.
I'm happy to say I'm cured forever ... but goddamn I wish I could give that to other people.