Believe it or not, there are many women out there who experience the same thing. One thing you should do is go to your doctor and have a full physical done. There could be a medical reason for your lack of sexual enjoyment.
The fact that you are able to enjoy sex, or at least believe yourself to enjoy sex, while drunk could mean that you are super tense and inhibited when sober, which could mean that there could have been a sexual trauma in your past. For that, I would recommend you visit a counselor to help you with those issues.
Either way, maybe now is the time for you to focus on you and not worry about having sex right now. Don't have sex again until you are really, really into the person and have NOT been drinking.
Please go see a doctor and a counselor.