IN/NOT IN vs AND/OR
The usage of an IN/NOT IN should result in the same data approach as an AND/OR. As the writing of an IN/NOT IN is sometimes easier to show the logic of a query, I mostly prefer this one.
So, for performance it should not matter. Maybe there are exceptions, but I don't know them yet.
Hope this helps,
BTW: this post has been made on my personal view. My employer might not share my point of view.