Back in the ol'days In iTunes package, there was a file called SortPrefixes.plist in localisation folders containing several sort prefixes (“The”, “A”, “An”, etc.). Removing them in this file was making iTunes to auto-sort everything including these prefixes (The Chemical Brothers was listed at T and not C).
(I have a lot of music files and I don't want to fix this by adding a Sort Artist to each of them.)
In the new Music app, there is no such file in Localisation folders, but I've just found a similar one in /System/Library/PrivateFrameworks/AMPLibrary.framework/Versions/A/Resources/XX.lproj/SortPrefixes.strings, containing the same samples of prefixes.
Since AMPLibraryAgent is managing libraries for Music.app and TV.app, I believe I might be on the right track and I'm tempted to clear them. But these files are stored in /System/Library/ so I don't want to mess with the system: does it sound quite safe?
(It doesn't look like a known trick yet.)
Best Answer
Rather than trying to coerce Music to do what it may not now support, you could try to use 'Artist to Last-First' from Dougscripts, and let the existing data work for you with a bit of automation.
https://dougscripts.com/itunes/scripts/ss.php?sp=mxartisttolastfirst
I've just given this a try and it works well, with minimal donation nag.