What happens when a dwarf is raised sober?
Perhaps, rarely, goblins with strong holds and deeper conceit, gripped with true sedition, turn pitiless eyes to the snatched. Sometimes, traders huddled in salted fields mutter even prisoners return from the dwarves, for seeds and stout coffers, yet they never seemed to welcome their own anymore, hadn't for long years. Captives forgotten, caravans warned off. Too often, the legends turned away.
Sobriety should bring out the worst in dwarves. Gold fever, grudges, social awkwardness, hesitation, more easily disturbed, dourness, greatly heightened or lowered morals, sensitivity to light and sound and a hankering for coffee are all good examples. On the other hand, they should also be much smarter, stronger and generally better then drunk dwarves.
Given that this is fantasy, perhaps the world shouldn't be too kind to those completely unsympathetic to fiction. Maybe slumbering terrors smell smoke, maybe magic is more chaotic then usual, either way trouble follows them like the plague.
Goblin's steal away dwarven children, so they're perfectly placed to force them to go cold turkey. If we follow that train of thought, smuggling, bootlegging and "poisoning the well" could gradually shake the goblins brainwashing and prevent several tall glasses of liquid nitrogen shattering in the face of all nearby.
Flipping the coin, the more interesting nobles could mandate prohibition, or perhaps cults of Temperance develop, which the player could help or hinder but will nigh certainly result in a AI rebellion. All the same smuggling and suspicious shacks should arise, complete with collaboration from dorfs outside the fort. You'd be relying on your guards to discover and report this, or by noticing "strange" behaviour.