In addition to this, the over-medicated moodlet itself has been modded to give your sims a more realistic experience. Notice however that this moodlet isn't cumulative, and won't change or have different consequences whatever the number of drinks. All bar drinks other than emotional drinks, motive drinks, water and tea will now give your sims a powerful dazed moodlet. This mod exploits the 'over-medicated' moodlet that's part of the sickness system in the Get to Work expansion pack. What does this mod change to the sims' behavior ? Move along, there is nothing to see here.
They act like plain H2O molecules on your sims' neurons (if ever those pixel creatures have neurons). Most bar drinks don't provide any special moodlet.
In the Sims 4, sims are as innocent as kids.