I'm tempted to say Resident Evil, even though one could say the bad writing is part of its charm.

Warcraft - love the setting and lore, but the actual in-game story and dialogue is just never-ending disappointment.