Breakfast of Champions movie was awful. Absolutely terrible. Mother Night and Slaughterhouse 5 on the other hand were both quite good.
And, I'd tend to agree. The fact that his books might incorporate drugs and alcohol (though, generally, drugs and/or alcohol are not the central theme) is irrelevant. A good writer can write about swamp sludge if he's got something good to say about it. Hell, read Fear and Loathing in Las Vegas if you want something that you can aptly apply your "look at me, I'm so high/drunk right now" bit to (and that's a pretty great book, too, BTW).
I'm going through my head, and it's been a while, but I'm ticking off his books I've read, B of C, Cat's Cradle, Sirens of Titan, Slaughterhouse 5, Mother Night, Hocus Pocus, Time Quake . . . definitely others that just don't immediately come to mind. He's probably my favorite author so I've read most of his stuff. I've never come away from any of his books feeling like drugs or alcohol were glorified. If anything chacters like the alcoholic Dwayne Hoover show the destructive qualities of substance abuse. Come to think of it, I'm not sure he was an alcoholic . . . maybe he was just insane. Anyway . . . I think that you can't be right or wrong about whether you enjoy Vonnegut, but it sounds like you didn't pay very close attention when you read him.