I hate this, but the way I fixed it was shortened a song on my MacBook and made sure i could see it in my Music. Then configure an automation on the iPhone (Shortcuts>Automation) that would set a tone when a certain person texted me - you can also do for specific works as well. I had it set to run automatically, and then tested it out.
I really don't like this change, and because i only had 1 different tone needed for a single person the automation worked. If it was for everyone/Everything - it would totally be a different experience.
It's not a great solution, but it at least works in the short term.