Well, the EMH definately has an advantage, though maybe they could program him some holographic drink.
Data was vulnerable to polywater intoxication, so maybe he has organic components that would be affected by alcohol.
Spock could "eat a bowl of termites and it wouldn't bother him" though equating alcohol to termites might be a difficult task.
Odo.. I am less sure about, though certainly in his "non-shape shifting" era he's the clear loser of the bunch.
As to the ENT candidate, there isn't a good one.. though perhaps Phlox would be the best choice.