Can Plex tell me which files in my library were scanned but not added (due to bad filename etc)?

You could install WebTools
https://forums.plex.tv/t/rel-webtools-unsupported-appstore/206843
It will list unseen/unrecognised movies.