Improve ScannerBuilder documentation in regard to $Filter()

### Describe the enhancement requested

Currently documentation of Scanner, as may be seen on [arrow.html#Scanner](https://cran.r-project.org/web/packages/arrow/refman/arrow.html#Scanner), feels very incomplete.

It is not clear how to for example filter rows to a fixed list of values, normally using `column %in% values`. One AI says to use `$in_set`, another says to use `$InSet`, none of those seems to work or be documented anywhere. Not sure if it is supported at all.
Other operators, like `! columns %in% values`, could also be added to documentation.
In general, many more examples would be useful.
How to combine two filters, can we call them one after another, or they have to be defined in a single `$Filter()` call?
How to combine with `&` and how to combine with `|`, if calling one after another.

### Component(s)

Documentation

Start with the Scanner documentation linked at arrow.html#Scanner and the $Filter() API mentioned in the issue. Verify the supported syntax for membership, negation, and combining filters, then document those cases with examples; done when the ScannerBuilder documentation answers these usage questions clearly.

Written by the indexing model from the issue text.