I don't like vinegary too much (or smoke/fermented flavor etc), I like El Yucateco Red*.

Though it is a bit expensive for a tiny bottle. So I made a few big bottles trying my own spin* from garden habaneros (orange) and liked how it turned out.

* I see the key ingredients: distilled white vinegar, citric acid, xantham gum and tomato paste EDIT: carrots is another trick, IIRC I fried mine with onions and bell peppers