There is indeed some gaps in filtering array columns. There isn't any filters that work with the elements IN the list.

Definition of done

• Add a new 'Contains' category under 'Attributes' designed to only work with list columns. Only nodes/edges with the provided string as one of the element in the list would be returned. The UI could be either the same as 'Equal'.
• Add a new 'Partition for lists' category under Attributes designed to work like a partition filter but with the elements in the list flattened. So for instance if a graph has 2 nodes with a list column with [a,b] and [a,b,c] the partition chooser would have 3 items a, b and c. Having percentages would be nice to have.

I completed the work:

• New "List Contains" filter under Attributes. Exact match on the list element, based on the user input. Only one element can be matched.
• New option on the existing "Partition" filter. When the attribute is a list, one can right click and select the "Flatten list" option, which will allow the selection of elements in the list.

One can use this example GEXF with a list attribute for testing
test.gexf.zip