Still not sure about Spotlight. In its most simple mode, it seems to work pretty well; but the moment I try to do anything remotely fancy something goes wrong. I tried Smart Folders based on time (modified in the last week, eg), and the thing is just dog-slow, takes several minutes (literally) to show results. The Raw Query system has no way of limiting based on Path (can't exclude "Caches" from a search on a case-by-case basis). Other weird stuff happens: files get excluded from searches that don't mention any of hteir key words, sometimes.

In general Spotlight seems another work in progress.