Quod Libet handles album artists properly with the right sorting options? (And also it's one of the few that supports original release date, another seemingly essential feature that few players support.)
In Musium (https://docs.ruuda.nl/musium/) I also handle collaboration albums that have multiple album artists, based on Musicbrainz album artist id.
If they changed something in the last year, maybe. But last time I dug into this in detail they screwed it up out of the box, specifically by refusing to use the same mp3 ID3 tag that most other software including Picard uses. So for FLACs it worked, but for MP3s it did not, until I went in and edited the code.
At the time, the developers claimed changing it to work as people would expect it to would break existing user workflows and so they wouldn't do it.
In Musium (https://docs.ruuda.nl/musium/) I also handle collaboration albums that have multiple album artists, based on Musicbrainz album artist id.