Tabasco and Frank's are for teething babies.
I like a few different ones. Cholula is the best of the mild, flavorful sauces. It's got just the right tang along with a complex peppery sweetness.
My all time favorite is Melinda's, either XXX or XXXXReserve. There is nothing like "The Sweet Hot B*tch". She's hot, she's sweet, she makes you want more and she lets you know you're out of your league. For those who don't like the really hot stuff, there are X and XX.

Chef Shaikh's Raging Inferno is a good tamarind sauce for meats, especially pulled pork.
Busha Browne's Pukka Peppa is very peppery (in a good way), with little other flavors. If you just want to add the peppery taste, this is the one.
Dave's Insanity has almost no flavor; he has better sauces, notably Hurtin' Habanero.
I'm not much of a fan of the Blair's Death sauces, Death and After Death; they just don't taste right to me.
Ass-Kickin' products are disappointing to me.
Bermuda Jack's Onion Sauce is very flavorful, pretty hot, and excellent on spaghetti.
Iguana Gold is mustardy, really hot, and great on rare burgers.
El Yucatero is a sauce I got in a little groceria. I use it on Tex/Mex a lot. It's very much like Cholula.
Capital Punishment is massively hot. I used to put it on pizza, but not any more. It's too hot for that. I can't think of what might complement its flavor. It's good, but I don't know what to use it on.
That's all I have in the house right now.
Tom