FILTER() - When, Why, and How to Use It

A recent comment/question alerted me to the fact that I've never devoted a post just to this very useful (and often misunderstood) function. Time to correct that.