Define failure. If you mean financial failure, there are hundreds of examples. Perhaps thousands. A game that sells well can be a financial disaster. Bioshock Infinite sold millions of copies and it was the final nail in the coffin of the its developer.