The "automatically handle large sets of repeatable values" setting is available for all field types that can be defined as repeatable (with the exception of Shopify » ... types, see below) and for all scopes except for product types, vendors and locations.
With "large sets" enabled the storage limit is now 1,000,000 characters, which allows you to work with sets in excess of 1,000 elements.