Get and use the
Quality check Plugin to find Author sort and initial problems.
This cant find all the ways metadata has been messed up (some by the publisher being inconsistent)
eg. Fn MI Ln | Fn Ln | Fn Mn Ln
Then there is the case where the data overlaps with another, complexly different case ( Series name duplication, Authors with the same name )
YOU need to intercede and pick how you will tweak the data to break the tie
For Series, I added the Authors initials to the series: Magic (AN)