One thing that has kept most problems to a minimum for me is that some time ago I made it a practice before adding any music to my library to check all the metadata tags in YATE, filling in blank fields and correcting tags for ARTIST and ALBUM ARTIST (or anything else) that were not consistent or didn't contain information the way I want it displayed, and adding ALBUM ARTWORK where none was found. I'm no longer surprised at the lack of information, or lack of consistent information that commercial releases come tagged with during their mastering process at the label. And of course, private recordings, or rips from R2R don't have any information and so all that must be supplied by the user.
i use tagscanner (a windows program, running under wine in linux) and a very highly proprietary method for fixing all the naming variations (Bach, J.S. Bach, J. S. Bach, JSBach, ad infinitum) and other poorly controlled metadata in tags, as well as to consistently name live concerts (i.e. "2017-02-14 Cargegie Hall", "1977-04-23 Springfield Civic Center", etc) which are stored in a file structure that i use to easily navigate between genres, artists, etc without the need for search (most of the time).
the proprietary method of fixing the metadata? i got my daughter to do it all over a week or so, going over my entire 7TB library.
it cost me a coffee grinder (so she can grind her pour over without disrupting the carefully tuned espresso setting on my coffee grinder)