Vomiting, alcohol poisoning and eventually death if you continue to force your character to drink would also be nice.
And urinating on yourself, and depending on what you eat maybe the combo giving you explosive diarrhea too! Y'know, complete with temporary "negative perks" like annoying everyone downwind of you until you can dive into an ice-cold river and clean off a bit! People in the streets pointing and laughing once you've wet down the front of your clothing, permanently affecting your reputation in that town as word gets around. "Hey look, there's that 'adventurer' that pees all over himself every time he's in the pub!"
Effects on quests too...who's going to ask a garment-soiling lush for help except maybe...another garment-soiling lush? Certainly not the noble in charge of a town..."Chamberlain, the treasury has been robbed. Send for that stinking, stumbling sot who was urinating all over town last night, I'm sure he can bring the bandits to justice!" "Er...my lord, do you have evidence that they're hiding out in a tavern? Seems to me that's the only way he would even manage to find them."
What do you guys think about this? I for one would love to play an alcoholic character.. one that cant go slaying dragons, exploring dungeons or grocery shopping without a good strong swig of happy sauce.
Only if they take it all the way.