"The spicier the food, the more water you drink (maybe)."
Negative. Water actually amplifies the sensation. The sugar in the desert counters the sensation, as does milk. If I go awhile without eating "11" hot, when I return I have to follow it with milk or sugar(or both=Thai Tea or Cafe Sua Da). Otherwise, the subsequent burning sensation can be quite unpleasant. I always go to "11" when I feel a cold or flu coming on to combat the contagion, it works 9 times out of 10. YMMV.
If I go too hot or if I'm making a really hot hot sauce, I'll go for citrus. The acid counters down the oils and help faster. In the sauce, it balances things. Same for pineapple.
There's also the link to certain spices (like chili peppers) that are highly anti-inflammatory.
Personally, the more spicy food I eat, the more I have dessert.