I was using HoudahSpot and Spotlight to track down some files and went down a rabbit hole for a while.
This is a companion discussion topic for the original entry at https://brettterpstra.com/2013/07/06/finding-files-in-spotlight-that-cant-be-mdfound