Look at the thread linked to within that topic on the device handler and you’ll see how people are using it.
Another alternative is just a Sonos type music player, although there are also many less expensive ones that will work with SmartThings.
The point is just that there are a lot of different ways to play different sounds for different sensors using SmartThings.
In the past, the trickiest part has been an actual button for The doorbell button. But now there are several options for this, including the aeon doorbell, The iris smart button, the flic button, etc.
But as far as triggering different sounds when different sensors fire, that’s pretty easy.
