I think there should be a mod which allows you to get high off of skooma, hist sap, or moon sugars ( for ur beasts ) and could also let u get drunk off of alcohol ( for u nords ) it would be funny and i think it would add purpose to the drugs being in game. u could rp ur khajiit getting high or ur argonian getting high and it wouldnt be right if ur nord didnt drink atleast a pint of mead every day.

I have an Oblivion mod that would let you get drunk, forget what it's called off the top of my head. It was honestly more annoying than anything else. I usually have a few beers in me while playing, that does just fine. Real influence + mod induced influence = not fun.

Realistic Needs and diseases has this option.

You can trip or fall over while drunk or even pass out if you drink too much.

It adds a blur effect too.