The overlay is not directly related to drunk or horny ... it indicates, that Sammy is in a very good mood ... be it from drugs, booze or steamy quality-time ...
It starts with mood 80 ... and gets more opaque the higher the value ...
If Sammy is in a very bad mood, the flowers change to a dark pattern ...