Here is a further suggestion for testing if you don't want to order a bottle of red pepper extract online.
As far as the tabasco:
First, I agree, anything that is not clear has too much solids in it, that will not vaporize and will gum up and destroy the unreplaceable wick of your atomizer.
There are much stronger commonly available hot sauces at, for example, an international grocery, like Dave's Insanity Sauce.
Get something fantastically hot, and then strain it through coffee filters until you end up with a clear liquid. Then you may wish to add some VG or PGA to that to thin it back some.
Or, get a fresh Habanero, blend it on liquify with a little PGA, let it sit for several days, and strain THAT through a coffee filter. However, I would say treat Habaneros almost as carefully as you would nicotine. Habanero juice can put your eyes out, swell your throat shut, etc. in concentration. It's one of if not the hottest peppers in the world. Then, thin that down before trying to use it. If a drop of it on your tongue is too hot to stand, it is probably too concentrated.
Try that in moderation; I would not want you to have a coughing fit.