If I let art styles or superficial design that kinda puts me off actually put me off, I wouldn't be playing very many games.
I think the baseline for aesthetics in games is pretty generic, which is usually what you get when you try to appease everyone. The Dante design everyone hated was reduced down to MAN IN GAME -- to great success, question maarrrk. Not saying the first design was the bestestest ever, but it's a recurring theme that things that stick out usually get filed down to something thoroughly inoffensive and safe. Including art styles.
Some of my favourite games are games I'd typically go "urrrrrgh" over until picture frames started coming off the walls. Gears of War, for instance. Gears 2 is easily one of my favourite games of the past generation, but everything about it aesthetically borders on comical, I find it so aggressively masculine and action figure-esquely grim. OH! Although I did fancy the Locust city bits, those were pretty interesting.
Really, aside from animations and other feedback related visual cues, video games and their looks are two wildly different components that both very seldom click for the same person. It's a total lottery, really, and dismissing a game that would tickle you mechanically because the art style doesn't click is frankly a bit of a luxury, in my opinion.