Intoxicated wizard + at-will magic missles. Brilliant.
Well, if you get proper medical care anyway.
I love the fact that being drunk or high lets you shrug off punishment, because that's what berserkers are. Because people have gotten drunk before going into battle as a survival strategy for millenia. Because it would be funny in actual play.
But I think I'd rather have intoxication give you temporary hp, or allow you to regain 1d6 temporary hp on a successful attack against you. That way you still need healing before you sober up, or you are in big trouble when you do feel the pain.
I don't actually think they had alcohol in mind. More likely something entirely different. ^^Just my $0.02 (USD), but Intoxicated doesn't have to mean drunk on alcohol.
The hidden dangers of D&D next - my idea of a wizard coven has forever changed from a group of somber, obsessed grey haired men pouring over musty books of hidden lore, to a fraternity of beer bellied hooligans in a constant estate of inebriation.

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.