First Name Last Name with any frailing words to Last Name, First Name and Trailing words

I was reading your comments on the First Name Last Name thread
https://community.mp3tag.de/t/switching-first-and-last-name-of-artist/11020/24, which I am scouring, once again, for solutions to my problem, and I want to let you know that just because I am switching names for artist like Steve Miller and Stevie Ray Vaughn & Double Trouble, I am NOT changing Pink Floyd to Floyd, Pink or East 17 to 17, East. That would not make sense. But bands like The Rolling Stones will be turned to Rolling Stones, The. Also in Latin music, you have bands that like Trio Matamoros, that released albums under Cuaterno Matamoros and Septeto Matamoros. If I did not place the Trio or Cuaterno after the Matamoros, separated by a ", " these albums and songs would not be grouped together. There is a method to my madness. Basically I am following the organization principles of a library. The scripts we were discussing were not meant to be used grossly across all songs but rather selected ones.

I know you probably think this is a waste of time, and you may be right, but there has to be a reason why sorting fields exist and this whole system was created in the first place. The question is if that initial reason is pertinent in today's world.