I love hot sauces. Ironically, one of my least favorite is the most well known: Tabasco. Regular Tabasco, IMHO, is too hot without adding much in the line of flavor or tangy-ness. I do, however, quite like the Tabasco-Chipotle (smokey) and the green Tabasco (milder).
Overall, my current favorite is a national brand called Cholula. Very good flavor and moderate heat. You can recognize it by its trademark wooden ball bottle cap.
When I want LOTS of heat, I use sriracha or thai chili-garlic paste.