I agree that flaming asshole level of heat is silly. But capsaicin activates heat receptors - people with less tolerance perceive it as pain but for those of us that can tolerate it, it’s more heat coupled with maybe just a little pain. Heat (or the perception of heat) can act as a flavor enhancer.