I dont know if this is a bug in Hazel or in Finder/Spotlight but the chance of Apple fixing bugs is slim, the least I can hope for is a workaround from Noodlesoft. Anyways:
I use Tahoe 26.7.2, but this appeared in previous MacOs:es also. Hazel 6.1.2 which says it is the latest version if I do "Check for update"
I heavily use Finder tags and Hazel to sort files. Add a tag to a file, and Hazel moves it into the right folder, tag a photo of our cat with her name and presto Hazel move it into "her" folder. But after tagging 4-6 files or so, Finder stops accepting tags, it would look like the file was tagged when tagging, but when tagging was done, file would have no tags. Pressing Option-Command-Escape and Relaunching Finder allows the tagging of an additional 4-6 files and so on.
I decided to try to stop System extensions from loading. And Hazel came up as the offender, if I unchecked the Hazel boxes in "App background" items and restarted my computer/relaunched Finder) I could suddenly tag files without problems (but I only tagged around 50 files).
I also tested stopping Hazel in the Hazel menu and tagging files and I could tag many files, I then Started Hazel and after a few files tagging again stopped working.
In both cases once tagging stops working at minimum a Relaunch of Finder is required.
I reiterate, I dont know if this is a Hazel problem, a Finder/Spotlight problem or a mutual cooperation problem between them, but I would appreciate if Noodlesoft could at least check this out. Could Hazel and Spotlight lock each other out? Am I the only one having this problem?