IN is for a list of values and it's an exact match. What you're looking for is LIKE with wildcards, but as you want to match multiple values I suggest using REGEX. Example as follows (Advanced filter).
( ue.`cb_area` REGEXP 'Hotels|Accommodations|Motels' )
The | in the above basically means "or" so you can add more, less, or make the current more specific as you please.