I guess any type of tweeter can sound like crap if it employs crap materials, is not designed well, or if the crossover isn't implemented properly. That said, you sound like a great candidate for a ribbon tweeter. I heard a pair of Selah speakers that sounded very sweet -- detailed with no harshness. Perhaps Goldenear, Dali, or Mark & Daniel as well?
Short of ribbon tweets there are some sweet-sounding speakers from Joseph Audio, Dynaudio, and Nola (all silk dome tweets) that have a detailed, refined sound that may not offend your senses as well. There probably are some good metal tweets out there too, but in the lower price ranges they may be a little more risky than these other alternatives. Best of luck.
Short of ribbon tweets there are some sweet-sounding speakers from Joseph Audio, Dynaudio, and Nola (all silk dome tweets) that have a detailed, refined sound that may not offend your senses as well. There probably are some good metal tweets out there too, but in the lower price ranges they may be a little more risky than these other alternatives. Best of luck.