To be included, a game must satisfy EVERY ticked option from the "What do you want" section and NONE of the ticked options from the "What don't you want" section.
So for example, if you tick "visual novel" and "comedy" in the "What do you want" section, you'll get all the games which are visual novels AND comedies. But if you tick "visual novel" and "comedy" in the "What don't you want" section, you'll get games which aren't a visual novel OR a comedy.
I am working from vague memory, so likely missed stuff. And I was half-assed about looking up whether things are available on console.