As has been said, any tweeter is only a good as the overall speaker design. The Focal Inverted Ti is a good case in point - a unit that can sound radically different in different applications.
However, purely to expand the field, plasma tweeters e.g. the Lansche unit do have some pretty special qualities.