It sucks have the same sound for pretty much every situation.
Would be nice if they separated the sounds. Like one sound for an event warning (phase transition, or big raid damage inc, etc), a different sound for a debuff on you (ie like Rot on you, or Xavius' blades on you, etc), a different sound for you standing on fire, and a different sound for a spell/ability that you have to interrupt.
Same sound for all these different things get very confusing, especially on fights like Mythic Xavius/Cenarius/Dragons where there are lots of shit you have to be aware of and my DBM is going off with that same horn sound over and over.