Let’s face it: the built-in file search in OSX really sucks. All is not lost, however, because Thomas Tempelmann has written a fantastic, robust search application called “Find Any File“.
It doesn’t integrate completely with Finder, but Find Any File can be docked for convenient use. I use it almost daily to locate files for work. You can drag-and-drop directly from the search results as well! The application works great, and is definitely worth the $6 he asks for it. I just wish that–with the prices they charge for computers–Apple would get on the ball and put a real search function in OSX.