If a large majority of your performer roles are messed up, I would honestly either import the entire collection into MP3TAG, delete those tags and then pass them to Picard to reprocess. If there are some albums where you believe you'd be losing the roles that wouldn't be replaced from MusicBrainz, you could just import all your albums into Picard and manually check them.
The former is the best route to go if you've never added custom roles. The latter is better if you have and it's honestly the best option. You can right click on roles that you don't want changed and click something like "Remove" to keep Picard from changing them.
I managed to do it with MP3tag by using a regex replace starting with the ones with the most roles and then modifying the formula, working my way down:
What:
(.+) \((.+), (.+), (.+), (.+), (.+), (.+), (.+), (.+) and (.+)\)
With:
$1 ($2)\\\\$1 ($3)\\\\$1 ($4)\\\\$1 ($5)\\\\$1 ($6)\\\\$1 ($7)\\\\$1 ($8)\\\\$1 ($9)\\\\$1 ($10)
Stupid? A bit. But it worked.
I've made changes to Picard to avoid this in the future, but I did run into another problem.
I'm using this formula as a virtual tag to get a tag displaying only the instruments:
$IsNull(<Artists: Performer>,,$RxReplace(<Artists: Performer>,"[^;\(]*\(([^;\)]*)\)","$1"))
This causes a problem as, sometimes, the artist name is added as a performer but without an assigned role, causing their name to end up in my list of instruments. When that's the case, Picard should delete that tag completely as it's essentially a duplicate of the artist tag.
Other times, the name of band members are added as performers, still without an assigned role, causing the same problem as above. Not sure how to deal with this yet. Either adding their roles manually, or assigning a generic role e.g "(Performer)" or simply deleting them all together.
Any tips or ideas on how to handle this will be received with appreciation.
There's a box in options labeled "preserve these tags from being cleared or overwritten...": https://picard-docs.musicbrainz.org/en/config/options_tags.html
You can quickly add a tag to this list by right clicking on the field name in the bottom panel. There is menu entry for something like "add to preserved tags".
Yeah, I found that one after a while. Still a bit scared to mess with files that are already 99% correctly tagged. There was a plugin(?) that added a $keep function to if I recall correctly which I assume does something similar.