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
Subscribe via Email
I am RSS years old and still miss Google Reader, but if you want to get inboxed when I post here, that’s fine with me.