When a file is right there on disk but Spotlight refuses to find it, two terminal commands diagnose the problem in seconds. mdimport -t -d2 <file> shows everything the metadata importer can extract; mdls <file> shows what made it into the index. When the two disagree, the mdimporter is at fault — usually a known macOS bug — and you can stop blaming yourself.