Set a sound alert for SMS only

[j7n]

Is it possible to set a sound alert that plays when an SMS arrives like on a conventional phone? I have a Showme Redmi 14C (Android 15). In Settings > Sound & Vibration there is a category called "Other notifications and reminders". SMS apparently fall under this. The problem with this is that there is a lot of notification spam, and they all make the same sound. Software updates, most apps ask you to show notifications, a flashlight app that shows a notification that the flashlight is on. I have turned off some but others still remain. Can I set sound for just SMS?

The sound customization is really lacking. There is no "ascending" volume, which make the ring start quieter and rise (in case the phone is in my proximity already). I need to bake this into the MIDI file.

[Tripredacus]

It seems to differ from Android version to version. I remember having a previous phone that I could set custom sound alerts for SMS for specific contacts, but then a later phone didn't have this option. There are apps that can do it but trying to find a simple clean app (especially these days) can be a real task. I had used apps to manage this before and they do work but not reliably. For example one phone I used an app for that, it would play the custom sound half the time and others it wouldn't before eventually it just stopped working. 

My current phone just has a default "Notification Sound" that is system wide, and the app I use for SMS doesn't have an option to use anything other than the system notification sound. I had a previous app that did but I never bothered to change it before it stopped letting me open it.