I don't know which games that I've played until now had the worst story of all time, because I can't remember every shitty story. But from the games I played recently it's Bayonetta (2010) and Brutal Legend (2009). Both seemed just boring to me (although I finished both).
(btw: I can't really understand why people say that MGS or FF games have bad stories. For me these are the best stories I've experienced.)
2012 - Top 3 [so far]
#1 #2 #3