There are two things to keep in mind...
Bodybuilders do not drink alcohol, especially not while cutting, because it will affect how they will perform in competitions.
Batman does not drink alcohol, because it will affect his daily training.
Myself, I'm a moderation person. I don't have a problem getting completely wasted every couple months if I'm serious about training as regularly as possible. Simply put, I enjoy the taste of alcohol, and when I go out, I end up drinking to excess because I enjoy the taste so much (and I am a FULL-blooded Asian who is NOT a lightweight). So long as nothing is extreme and nothing is habitual, I don't see that much of a problem.
As for calories, there are certain drinks that have none (vodka-tonic, gin and tonic, vodka water bomb, etc.), and the effects on training will be purely the alcohol, not getting chubby.
The red wine thing... people actually recommend a glass a day to reap the full antioxidant effects of the wine. A glass of dark grape juice will do the same thing, though!