I want to have regular folders, and then folders that I can issue a SQL style query to generate their contents.
Take multimedia. With a traditional file system you can only have one type of sort. Typically by type (audio, video, image) and then alphabetically. It would often be nice to have a folder that is formed by querying the metadata, say all the items released in the 1950's, or all the items that are a low quality copy.