A couple years old, but still useful. Some basic ideas about how to use Smart Mailboxes in Mail.app from Merlin Mann, who tends to be pretty good at that sort of stuff.
Some handy Mail.app Smart Mailboxes – 43 Folders
⚠️ This post is more than five years old. Links may rot, opinions may change, and context might be missing. Proceed with cautious optimism.