It was very well implemented in LoTRO (pipe-weed smoking was really cool too), they even had events centered around drinking games, like getting drunk in every inn of The Shire in a certain amount of time, you'd run from one inn to the next with your vision going to shit, it was a pretty awesome break from regular MMO activities.

So yeah, I would like to see that kind of thing in FFXIV. It doesn't take away anything and it can be fun.