This is a uniquely new-macOS issue. Spotlight has never worked well since the big redesign in 10.10. In the snow leopard days it was predictable and seemed to be ordered by frequency of use. (There were occasional issues where the entire launchservices DB got messed up, but this can be fixed with an lsregister reset without reindexing all of the files).