I don't find alcohol helps me at all; it takes an edge off me for several days. I very rarely drink, almost only at special occasions and then matched wines with meals and that kind of thing.
But I do find that being somewhat tired helps me get into a certain kind of "getting things done" zone: when the creative planning is not necessary, and mostly the grunt work of pushing things through to implementation remains.