So I have found the bug, I wasnt seeing it because it first uses AlbumArtists field if has value (and my files do), then only if empty uses AlbumArtist field. What it is meant to do in that case is look for an exact match Artist match in MusicBrainz and if couldnt find one check if AlbumArtist could refer to multiple artists but it wasnt returning after the first call.
The Issue will be fixed for next release. But if you wanted to try out the functionality then the solution to work round problem would be to copy contents of AlbumArtist to AlbumArtists and Artist to Artists first, and then Add to MusicBrainz Release will work
e.g
Regarding your other questions, the idea is that Add To MusicBrainz would be run after your songs have been matched to MusicBrainz, usually via SongKong, but also could have been done by Jaikoz or Picard. So at this point SongKong is assuming these albums are not in MusicBrainz, and is certainly not relying on a preview task you may or may not have done, it is just using the information currently in the files.
In general the database is just used to allow processing large libraries without requiring large amounts of memory, and for performance so we dont have to go back to the files to read their metadata at each stage. The only exception is the database is required for the Undo task, but other than than you could empty the database after every run without any loss in functionality and just a small loss in performance if reprocessing the same files.
Now if the album is already in MusicBrainz then it should come up as a duplicate on the MusicBrainz Release Duplicates tab as it did in this case
There can be many different versions of a release, not just re-releases, but format and country specific versions ectera. So although it may look like the release is already there we don’t assume it is, we assume that attempts have already been made to match to MusicBrainz and therefore if not matched it probably is not there. It is your responsibility to check yourself before adding a new release to MusicBrainz, the Add to MusicBrainz Release task is just a tool to make things easier and quicker.
I also checked to see if Silver City would be matched by Fix Songs and it was, so if Fix Songs was run first for real then it Add to MusicBrainz Release would try to add it because it would already have MusicBrainz Ids. I don’t have the Fred Neil album so cannot comment on that one.