I'm not a fan of western cartoonish 3D style - like Tales of Arcadia in movies, Torchlight, Warcraft 3 onwards... especially if there is supposedly a serious and dramatic plot...
For me this always looks half-baked - give me either "realistic" (Witcher) or "art" (Little Nightmares).

As for pixel art... there are two problems:

1. There's too much of it.
2. Too many devs don't understand what makes pixel art work: It's a way of abstraction (see the Bit-Trip games), and it's a means to an end: convey to the player in one glance what is going on.

In the old days abstraction was a thing of necessity. Mario evolved this way from the limitations of early arcade machines and consoles. Nowadays it's a choice, so at least some artistic understanding is needed to actually say something with it. Otherwise it's just a filler. Something makeshift that never got a proper replacement.
It's the same with low-poly (possibly untextured) 3D - there's just not that much of it. A skilled artist can make it impactful, a good designer can make it work, but a lot can go wrong along the way.

What I see as "none-functional" is low-res fonts in a game with lots of text and/or numbers. I find them really hard to read. Old games like Champions of Krynn had an excuse - it was the best they had. And also screen sizes were much smaller. Nowadays a single short sentence spaces out over 40cm in huge blocky "ornate" letters of 8x8 pixels - that's just shit.

WilderMyth's paper cutout style.

Maybe Environmental Station Alpha's extreme minimalistic retro-pixel style too.
Though not on account of the pixel style. I love it. See way too many people harping on it because they're some kind of graphics snobs, or think it's "old". No, I dislike ESA's style because you can't see what's what. It's about not hindering gameplay.

This

No exactly an art style but a palette.The Default CGA palette turned relatively decent graphics in somethig harming for the eyes. Ocassionally there were two switchable alternative CGA color palettes. But not too common.

I don't mind cell-shading as long as the environments are interesting... but the loss of detail can make bland environments look beyond cheap (in a bad way).
I feel the same -- it's based on tone.

But with that said...

... I'm enjoying For The KIng which is a very childish and cartoony style. Dunno... it's really destroys my thesis... Although, IMO it's easy to play for 5 - 10 mins and then walk away. I enjoy the game but I'm not invested in the game.

I'm not usually put off much by the art style in games, but one thing I really dislike is cartoony graphics in WRPGs. I like my RPGs to be dark, gritty and more realistic. So the graphical style of games like Torchlight and Dungeon of Naheulbeuk really puts me off. This also applies to World of Warcraft and D:OS was towing a bit too close to that line for me as well.

However, I don't mind anime-style art in JRPGs. It seems like it's par for the course and it's been a part of that culture for a long time. But, in a WRPG ... no.

I also very much dislike the art style in The Outer Worlds. It seems to be dominated by a garish, over-the-top pastel-shade colour scheme that seems rather contrived. Yuck!

Yeah, I think we're coming from the same place here :-)

I'll jump on the most-new-pixel-art-games bandwagon too.

And anything macabre/grotesque is not for me.

Also, every game from Amanita Design for some reason.

I do get this, but I tend to find the boxart the most offputting for the series.
Four, technically. And that's only for Component/Standard CGA. Composite CGA could do up to 16 colors. (But was rarely used over RGB because Serious Business Machines.
Funny thing, I've seen people argue that IV was too cartoony compared to III.

yup, I personally hated the look of IV. My issue isn't so much that it's cartoony as being in that 3D space where it's neither stylized enough for the resolution the assets are at, nor detailed enough for the resolution of the game.
Not a huge fan of the look of V or VI, but VI is definitely the best the series has been gameplay wise since the Call to Power games.

I find all of those adorable... but obviously tastes differ :-)

About Civ I am the weird boy apparently. To me the most artistic, quality and stable graphics are the three and the six ones.

The fourth ones are generic 3D engine era graphics, never liked them, the third ones are quality well animate 2d sprites, maybe voxel graphics. The Civ V graphics were too overworked. In the last game all is more polished and natural, colorist and with a more serene UI.

"Pixel style graphic'

Ew, it's just a lazy game design nowadays.

Things that mix resolutions in their pixel art or do "fake" low resolution (as in the art is low resolution but the actual rendering is being done at a much higher resolution.

Contrary to a lot of people here, I never tire of well done pixel art - I just can't stand badly done pixel art.
So lazy, right? I bet they must have knocked that out in an afternoon.

I'm not a huge fan of the early 3D look some games like Dusk are emulating. I mean I can still play them just fine, but I don't really have fond memories of that era and feel like games went 3D a little too soon. Amid Evil made it work better by being super colorful though. I'm gonna play the s*** out of Gloomwood. But do I wish they looked closer to 2000 than 1997? Yes I do.

I also have a biiiiiiiit of a hard time with ancient 2D renders with 3D polygons over them like Resident Evil or Final Fantasy VII. Not even because of the clunky characters, but more how blurry the backgrounds look on modern displays. I know some AI work has been done by modders, I'll need to check that out, but the raw versions on Steam or whatever are distractingly blurry for me. Early PC RPGs like Baldur's Gate have the same issue, sadly, though I'm more into that genre so I can swallow it easier.