It is up to the agency to pick their alert sounds. Quality of audio will depend on the competency of the agency installer and methods used. It simplify reads selected info from CAD. If the agency does not have it configured properly, that is on them. Also, it's not a crystal ball; it can't give information that's not there. A dispatcher has to add useful information in CAD. Garbage in is garbage out.
It has plenty of redeeming qualities, most unseen to the public. It's there because the agency deems it a benefit- it's not there for your or other hobbyist's pleasure.
I'm looking at it as a firefighter, and what is useful information as the crew is heading to the truck. It gives the basics, but frequently gives unnecessary information. Often, I hear the name of the person, or alarm company, reporting the issue, including phone number.
I know that if the call taker did not, or could not, get certain bit of information, that it cannot magically be added. If the calling party's information is overtaking useful information, then there is a serious flaw. Hopefully that information is available via phone app, or on a terminal or tablet, in the apparatus.