StarCraft: Ghost is a classic example. It was supposed to be this tactical stealth take on the StarCraft universe. Looked so cool in the previews and then... nothing. Vanished like a ghost, no pun intended.