Rather than waiting for this to be implemented, I have installed a 3rd party Android app that will customize the sound of the notification for every individual device or device type as well as every type of notification (person, vehicle, sensor, automation etc.) Among many many other programmable actions and behaviors.