Also, did you know that the SP players of C&C screwed over the MP players again and again? If you did not know that then I can understand that you would/could think MP people are crazy whiners etc. However, now you know why.
Coolness's idea would simply be a perfect solution, if it could be made easily. It could make story and real gameplay go into one, then both parties can directly be happy.
Keeping MP alive is the key to get a successful game, a successful game will mean that more people would buy a new title from that same developer.
That you want a story, I can get in. It's normal for a game. However, you could also be less greedy about having a whole movie game and give other people some MP fun as well. MP fun as in getting a better balanced game and better maps etc.