Is it actually a good idea to have recovering alcoholics in positions of power?

I've been rewatching season one of The West Wing, and in that show there's a plotline where some political opponents of the President try to embarrass his Chief of Staff, Leo, by revealing that Leo spent time, seven years ago, in treatment for drug and alcohol addiction. And in the show, this is treated like a completely cynical and absurd move, because…