Socks the Cat, the game about Bill Clinton's cat, that someone seriously thought was a great idea.
The game got made and even reviewed in some magazines, but just before it hit selves someone had a moment of clarity and pulled it entirely. With 0 sales its a pretty good fit for biggest failure, I'd say.
The game has Socks fighting Nixon through, so maybe it was alright...