In my country we mostly use WhatsApp and it has a specific option in the menus that says ‘in chat notification sound’ which does exactly what you are looking for.

What I would suggest is try another messaging app that is more feature rich such as textra. I bet they do a better job at handling notifications than the default app.