Weed massively increases creativity in everybody I asked, sure as hell does for me. Its not very controllable, ideas comes semi-randomly and works with topic processed previously, but damn so many results are actually good and stand test of time (I mean decades, like apartment interior design).
Alcohol? Social lubricant for sure, but creativity is contained only in the mind of a drunken fool who thinks better of his ideas than he should. That I never experienced, nor have witnessed and I certainly didn't avoid such situations.