I personally have no preference regarding art style. As long as the style is “competently done” then I don’t think I’d have a problem with a game’s look.
I do think that some art styles can work better with different genres. Pixel art might work better with a retro-inspired game and hand drawn art might go well with something more narrative driven.
For me a game’s art style doesn’t affect my judgement of the game’s value. I think some people perceive pixel art to be “cheap” but when well executed it’s gorgeous and difficult to make.
Not particularly niche, but the Danganronpa series! It’s amazing to me how consistently good all three of those games are, especially since each one keeps upping the narrative ante.