After a week of trial and error troubleshooting it turned out that the issue did not occur when I logged in on my Mac account with the password. It seems that the fingerprint log-in causes some hiccup.
I still don't know the root cause of this, but not using the fingerprint sensor (nor Apple Watch if you have one) may be a workaround in your case too.
Mind you, Alfred uses the Spotlight index, so if Alfred produces correct results the Spotlight index is OK.
What remains is that the Spotlight search engine starts producing incomplete results.
manusz got a reaction from howdytom in Spotlight indexing issues in Ventura 13.6.1
