For flavour, I like the 2 Tabascos - red and green. Hot is important, true, but past a certain point it's overkill. If hot and lingering are the main requirements, there's a local product called Tio Juan Salsa Picante.