As i understand it, one cannot give consent if one is drunk or drugged. So draw your own conclusions.

As long as you consider him a great guy, you will continue to put yourself in danger of being sexually assaulted by him.

I'm sure he is an attractive, charming guy. But so was Ted Bundy.