I find it odd that the preview and image show in photos, but the file is no where to be found
Photos is storing the previews and thumbnails of the edited versions and the original image files separately. You can see the thumbnails and even enlarge them, view the Info panel, even if the original image files cannot be accessed. Only, if you want to edit, export, or share the image, Photos will notice, that it cannot find the original file.
Also, the folder it's asking for, CFG111, when I give it access it still says it's not found.
When you are seeing the second panel "Could not find the original image file .... Would you like to try to locate it again ....", try the "OK" button. This should open a file chooser panel. Select the original you found with Find Any File in the Masters folder. If Photos does not let you select a file in the Masters folder, copy the file you found with Find Any File in the Masters folder to a folder on the Desktop, and when Photos ask "Would you like to try to locate it again" select the copy on the Desktop.
Does that work?
If not, use brute force and reimport the file you copied out of the Masters folder.
Do the same with the other photos that cannot be found.