I have personally programmed a lot while tipsy (never drunk, I am not sure I would want to read that code in the morning) and it allows me to get over the humps of writing that utility function that needed to be written but I was putting off, it allows me to just start putting code down in vim without really worrying whether or not it is good enough... Let me quantify good enough a little better. I am a perfectionist…
Coding drunk is not for everyone, it won't make you into a super-coder that can do everything magically, but if you're like some of us, where perfection limits production, being tipsy or totally drunk breaks those barriers and allows you to just do the job.