I’ve always sorted my folders like this
Artist (A-Z)
Various Artists
Then each artist has it’s albums alpabetically sorted underneath. Keeps everything sorted nicely. Various Artists contains compilation albums and collections.
I’ve ripped my own music CD’s with dbPoweramp and completed the tagging, if needed, with its accompanying app. For the rest I have tagged everything with Jriver Media Center. I have a master license for it, so I can use it on my MacBook Pro and on both Windows and Linux on my dualboot NUC.
Not sure how well Jriver holds up when it comes to your search criteria. But for general tagging I find it to be a very useful tool. I believe you can trial it before deciding if you wish to buy it. https://jriver.com/
