I really hope this isn't referring to any of the Jak and Daxter games they developed.

Wont elaborate, but TLOZ Skyward Sword is my go-to for this topic.
To a lesser extent, Death Stranding.

David Cage.

Every game he's made.
Yes, I enjoy them and I often enjoy the stories but they really aren't fun to play. Don't think I've replayed a single one of them after I beat them once (even though I always intend to). After about half an hour, I move on to something else.

Metroid Prime comes to mind.

I have yet to like anything they have made. Didn't like Jak & Daxter either.  Felt like about any PS2 era platformer to me. The second one tried to be GTA and was just dumb.

The Legend of Zelda: The Wind Waker comes to mind. The visual style of that game is so filled with personality and has aged extremely well. Unfortunately below the surface the gameplay is painfully average by Zelda standards.
Of the Naughty Dogs games of the 7th and 8th generation I have only tried the first two Uncharted games, both of which were more about visuals than being games that felt good to play unfortunately.
The first Sonic Adventure had outstanding graphics for the time, the game itself was completely broken though.

Omicron is actually quite good game (something that fans are still hoping would get announced sequel some day), if somewhat unpolished and bit too ahead of its time. Indigo Prophecy is fairly solid experience, if you like P&C adventure games. Rest...yeah, he went too much in indulging his inner Hollywood director wannabe.

The Witcher 3 and Red Dead Redemption 2 are are stand outs for me from this generation. Both games look amazing, but the gameplay is a cluncky mess. Worst of all traversal is terrible in both titles, making exploring the beautiful worlds a painful expereince.

There are probably others, these are just the two I really wanted to play, and look absolutely amazing, but I had to stop playing because the gameplay was so bad.

I think that might be due to the point and click narrative driven aspect of it. I love the genre, but I will never replay those types of games because one I've played a long story driven game and figured out the mystery there is little reason to come back to them.

Games like Teltales the Walking Dead series, The Wolf Among Us, Until Dawn, Life if Strange, Heavy Rain and most recently Detroit: Too Human etc are all good games though not games I play to 'play' a game. More like if I wanted to watch an interactive novel, but have my own choices and path.

For me, FFXV comes to mind. A great looking game but horrible and unsatisfying combat. Not helped by terrible controls and camera angles. Then there is the barren and uninteresting world and the traveling, which takes too long between missions. I could deal with playing a FF with its usual convoluted (but usually interesting) stories but I had to put my controller down after a few hours. Game reeks all style, no substance.

Detroit:Become Human
Crisis 3
Heavy Rain
Beyond: Two Souls
Final Fantasy IX
Final Fantasy XIII
Final Fantasy XV
South Park: Stick of Truth
Legend of Zelda:Twilight Princess
Super Mario Odyssey
Mario + Rabbits Kingdom Battle

Can't think of anymore right now.

Edit: Red Dead Redemption 2