You might want to check out the Smart Folders that come with Apple Mail. Not the fastest solution for me on my iBook, and the queries that you can perform are very basic, but it has some of the features that you've discussed, like "a folder that contains all email that contains the phrase "Slashdot effect" and is less than 90 days old".