Edit: I seriously don’t understand this subreddit, I state a factual “you can set up custom sounds for specific people” as I literally have custom sounds for multiple contact right now and then people are like “welp time to downvote as if you said something that is incorrect!”

Unique sounds per individual as in person in messages and calls? That can be done, but otherwise per app notification sounds is kind of an annoying area as it completely relies on the developer to provide a custom notification sound otherwise it does a default one.