There is a mod called "Red Alerts" by Supercheese here: https://forums.factorio.com/viewtopic.php?f=92&t=19579
It does play a few of these alerts on certain events, like when a vehicle or player gets destroyed. Its still on Factorio v0.14 though, you might try to ask him to update that one since it better fits your description.
But I may make a mod like that in the future, who knows. Thanks for the Idea.