Spotlight works great for me but the index can occasionally become corrupted. There’s a set of commands you can run to force a rebuild if you’re having issues. I’ve had to do this a few times over the years. This is another place where it’d be nice if Apple had a GUI to manage things like this.