Relationships are the building blocks of our wholeness and health.
I would encourage you to have a frank chat with your BF about this topic. Find out what need or desire he is trying to meet through his obsession. It sounds like there may be something inside of his own being that is hurt and could use healing. If I were in your position the convo may include questions such as "When you are aroused by someone who is incapacitated, is it because you are in control? Does it have anything to do with the fact that you can't be rejected by that person?" Just general questions like this can help open the door into healing for both of you.
If he refuses to open up about this topic, seriously reconsider the relationship. Relationships are about relating.

The one statement that bothered me most in your post was this:

"...he makes me drunk ..."

This is not an acceptable or healthy way for anyone to live. If he is forcing anything on you, it is an alarm BIG TIME! Get as far away as you can from any relationship where a person even hints at controlling you. Life is too short for that nonsense.