Spotlight straight up broke on both of my Macs after Sequoia. It can't even find exact matches in many directories marked for indexing and re-indexing did nothing. Just searching for apps under Applications doesn't seem to find all apps.
Then when it does show the results, they’re usually in some terribly unhelpful order. It took me ages to try and go through the CUJ of “this app isn’t sending me notifications because I turned them off now I want them back on”