I would like to set up some kind of workflow that will automatically delete a folder and all files within it two weeks after creation.
Prior to to Sharepoint I had never heard of a shared drive or even seen a folder structure so I took to metadata (column tagging) organization right from the start.
There are many posts out there extolling the virtues of using metadata over folders for organizing information in SharePoint 2007. I certainly believe that metadata is a great tool for for classifying information, but it is incorrect to ask whether to use folders or metadata to organize information. Rather, it is more appropriate to ask when to use folders and when to use metadata.
On twitter, @PirateEric is lamenting the fact that users INSIST on creating folders.
One of the first steps in getting End User buy-in is helping the user understand the new paradigm shift: A library is not a place to store folders, it is a way to organize your files into large chunks of information that can be sorted and filtered for quick access.