There is a 3rd party app called Random Notification Sounds, that makes your messaging app play a different sound every time you receive a text message. It chooses at random from a list of short sound files you add.

It works pretty well with Textra, about 60% of the time. I am requesting Textra adds native support for this function.

Textra is pretty great visually, it could be better audibly.