There's some dialogue options in the Dwarf beastmen dailies.. or was it the healer role quests? Ah, whatever. You're given direct options to drink a few times throughout the SHB MSQ, and a dialogue option where you can have your WoL say that they enjoy alcohol or not.

Some of the food options in the game are alcoholic by description. Frozen Spirits from HW is a drink made with ice crystals and fermented cloud bananas. There were a few others.

NPCs get drunk all the time and are shown drinking too. Hell, the intro to the game has a drunk merchant chat you up in the cart, followed by a moogle swindling his booze.

I'm a big fan of the toast emote, and I would love if we had more cutscenes where we're given the option to drink alcohol, but I don't think we need an intoxication system in game. The novelty wears off quickly, and it's not nearly as fun as playing while actually drunk.

I'd like to sit down and have a drink with Thancred, Estinien, Hien, or Merlwyb. Heh, I would have loved to join in on a round of drinks with Moenbryda and Thancred. As long as it's centered around characterization and story, then I have no problem with it.