You are both right. Apple does not support to change it. But the app developer can add it to its app.
And i also like to have the feature. So i can use a doorbell sound on the phone when somebody pushes the doorbell. But a security sound will be different etc…
