Specialize `CONTAINS_OP`

# Feature or enhancement

### Proposal:

I'll work on the following specializations:
* `list`
* `dict`
* `tuple`
* `set`
* `str`

### Has this already been discussed elsewhere?

No response given

### Links to previous discussion of this feature:

_No response_


### Linked PRs
* gh-116385
* gh-116464