One way to get all artists and their albums is to go to the Track browser. Make sure that you are displaying headers for the Album artist, (track) artist and Album, then select all tracks and export to Excel. You can filter the resulting spreadsheet by track artist, album artist and album…
The answer to your second observation came up a few hours ago in another thread: