How to create a spotlight search for all files inside a folder?
After some more research, it reminds me that finder's spotlight had boolean UI since OS X 10.5. You can filter for "not a folder"  for All My Files experience, or with a little bit more filter  for "all files".

It feels a bit hack-y though.