I can name a dozen but for the threads sake I will only name 2 and the story twist in SPOILER TAGS.
Gone Home. The game advertised and sold itself a horror game. I wanted to play a horror game. What I got was a mundane walking sim in a house about
Bionic Commando 2009. Back when Capcom was doing all these shitty gritty reboots like DmC, Bionic Commando and such. Our main hereo white guy with dreads with robot arm is looking for his wife.