Fully agree with this. I swore never to have any alcoholic beverages ever again in my life (and I make it clearly known whenever necessary), and having it forced on me, even in a game, feels a bit disrespectful. The "tipsy" debuff afterwards just adds insult to the injury. Like not only did my avatar drink alcohol (which I refuse), but it also implies that I drank enough to be at least tipsy (nobody would see me dead in a drunken state). Not to mention that it delves in the territory of alcoholic beverages being a societal choice instead of an individual choice, but that's a rabbit hole I do not wish to enter.
As for modifying the cutscenes to allow a non-alcohol preference, it doesn't have to be huge changes. Like when Shane offers you a beer, instead of showing you drinking it and him responding by "wow, you're a fast drinker", it could instead show you do nothing and him saying "Ah, you don't drink? I guess that's a good thing." Or the sequence with him offering you a beer could be removed altogether, I don't really see why it's necessary, especially since he warns us about the dangers of drinking. Make up your mind!
And for Elliot, given that ordering for someone else without asking is already impolite, the entire cutscene could be redone at this point, without even needing a specific "no-alcohol" option at character creation. Instead of him ordering for you, he actually asks andyou get a dialogue box allowed to choose between wine, beer, sparkling water and whatnot.
That does require a bit of rewriting and recoding, but these are the only two instances where the player character has no choice regarding the consumption of alcohol for themself, and the quest for Pam can be modded as the previous poster mentioned. Outside of that, the entire game can be played without ever crafting/buying/consuming alcohol, and gifts of beer can just be trashed or sold anyways.
