Why are regular Folders in Smart Folders not showing up in Open File dialogs?
This is indeed the expected behavior, as explained in this article by Howard Oakley. The article deals with tagged folders, but the behavior also applies to Smart Folders.