None of those was half as stupid as Dirge of Cerberus.
Twilight? Softcore porn for women.
Mass Effect? It's far too generic to count.
Sonic? That's pretty insane, and probably the closest runner up I've seen.
Still, it didn't involve the world's biggest emo turning into the GOTH LORD to take on a shirtless not-dead dude who is being possessed by a crazy professor he downloaded from the internet. Said professor's goal is to take control of the entire world by tricking it into thinking the apocalypse has begun by murdering...oh fucklesticks, I can't take this anymore.
Oh, and the end boss is alluded to having a near-incestuous relationship with his brother; his brother being a man who regularly wears a straight jacket; complete with a jock strap on his face.
Did I mention that the protagonist's love interest has the body of a 9 year old when he is nearly 60? And it just so happens to be possessed by the fragmented mind of his previous love interest from 30 years ago?
There's no way to summarize what happens in that game other than "Indescribably stupid/pointless shit happens. It involves Final Fantasy 7. The End.".