I swear, there was already a similar conversation about this...

Anyway, as some others already pointed out, the noise the macros make is about getting your attention, preferably about something important. An example of something important would be mentioning you just cast Eye 4 an Eye on a particular player in the party, so that others don't waste their Eye 4 an Eye cast on the said member until later.

I've only met a small handful of players out of all who play the game that actually use macro sounds in annoying ways. *Ears are still ringing from a "BATTLE BONGOS!" run in WoD where someone kept SPAMMING the macro over and over again and never actually helped in the fight*