I love story and i can´t care less for MP, so, i would get the game if i had a PS3, but that is not the point, i´m not talking about my take on the game, but a more broad opinion.
I agree 100% (not the indifferent toward Bungie and Infinity Ward part, i´m not indifferent to any developer; but the all "I play games primarily for their stories")
Bioware is, IMO, the best developer there is, i´m a huge fan of them since Baldur´s Gate.
But, a game doesn´t need to be an interactive movie to tell an amazing story, and that is, imo, the biggest flaw of the game, the GAME part.
But, once again i say that i would buy it if i had a PS3