The past 2 years Mrs. C has given me hot sauce Advent calendars, so I get to try 20-some hot sauces in small bottles. Usually takes about a year to go through them all. Some of the habanero / Scotch bonnet sauces have been eye-openers, in both ways. I had not been using those sauces but discovered that the combination of fruity flavors with appreciable heat enhances many dishes.
Otherwise my staples lately have been Melinda's Extra Hot, Tiger Sauce (sweet, mild), and Cholula or Tapatio.
I generally do not enjoy Tabasco or Frank's, unless I want a dish to taste strongly of vinegar (which works well for collard greens).