I love fresh made salsa. As far as store bought brands......Frank's Hot Sauce has a great taste, but isn't very hot, but it taste great. I espcially love Texas Firehouse Habenero Salsa from Corpus Christi, TX - (it is made by a couple of Corpus firemen), and it has a nice burn to it. There is a datil pepper sauce you can find in St Augustine, FLA that is out of this world marketed under the name Dixie Datil, and my favorite of the Dixie Datil is Outrageous Orange. I am a big time chili head and I think Outrageous Orange is the best tasting hot sauce you can buy.
On a side note, Dave Ultimate Insanity is the hottest stuff I have ever found. I eat lots of hot sauce and many fresh hot peppers and Dave's Ultimate Insanity is just too hot! A bottle last a long time.