You're probably just sensitive to capsaicin. I love hot food, and it takes a lot for me to end up in agony like you described. But I've definitely been that guy at an Indian place where I'm sweating profusely while telling the staff the food is delicious.
Finding a hot sauce that tastes good/doesn't taste like hot garbage is harder than actually eating food seasoned with it.