For American and Mexican and many many dishes, you can't beat the Kings:
This is just based on flavor... second best to me is Crystal:
But there's specific hot sauces that go better with their own cultural culinary heritage, like African, Chinese/Vietnamese/Asian and Caribbean. I don't even know the names of most of these, they're served without the bottles or labels most of the time.
But for taste, Tabasco is unique and amaaazing.
:D