It can be fairly efficient with small lists (hard to say what small is, but at least into the tens/hundreds) for $in. It does not work like app-engine since mongodb has actual btree indexes and isn’t a column store like bigtable.
With $in it will skip around in the index to find the matching documents, or walk through the whole collection if there isn’t an index to use.