I try to take amazon reviews with a grain of salt, sometimes they tell more about the reviewer than the product.
In the case of the aeotec doorbell, I use it for its primary purpose, ie a doorbell with the included button remote. But others in the community use it for all kinds of alerts by customizing the mp3s saved to the device. Check out the thread on @krlaframboise’s advanced device handler. Personally, I’d give more weight to the experiences of people here, over the impressions of sometimes vapid amazon customers.
You could also customize the sounds you receive from your SHM alerts.
The screen you found above, with the modes, restricts that automation to run only in the specified modes, if you check any of them off.
So what you could do is create one SHM alert with a push notification and set it to run in the mode(s) you use when you’re home and awake, for example.
You could create another SHM alert and restrict it to run in night or away mode, this time set it to send an SMS to your phone. Add the # that sends you SMS texts from ST to your phone’s contact book, set the sound to something that’s harder to ignore than a standard push notification from the ST app.
Now you’ve got two different kinds of notification sounds for the same trigger(s), depending on time of day.
Just keep in mind you’ll have to create other automations that change your modes based on whatever conditions you’re interested in using, if you don’t already use modes. The modes are a higher level restriction that can be applied to many different smartapps.