Why was he more affectionate drunk?!?

When he is drunk, he probably has a visual of you in the form of a giant teddy bear. If you want him to be like this all the time, you will need a giant teddy bear costume, and you will have to wear it all the time near him.