I'm fortunate to have the same problem with alcohol. I can get up to drunk (though I won't feel 100% the next day), but anything beyond that stage and I start to feel ill. Especially back in college, I remember other students regularly getting to stages well past drunk (e.g. "wasted", "trashed", "black-out", etc.), and enjoying it, but I only ever did a few times and was always completely miserable.

In the end it was just my body protecting itself from the stupidities of the brain running it.