Notification tunes

Can the tunes of notifications, e.g. Ring Bell & Entry delay etc. be set to different one from those of social apps to draw attention?
There are so many notifications nowadays on a mobile device that one can easily ignore important notifications like door bell rings.

For me, luckily, I don’t use social media, but if I did I would likely turn off their notifications as they aren’t important like a Ring notification which I do care about.
For me the only notifications I have on are phone calls and text (only from certain people), bank apps, and Ring. Everything else doesn’t warrant my immediate attention. You might try the same to reduce the amount of non-important notifications on your phone.