You forget about the EMP, which is fast becoming gamings new Laser Cannon >.< Hitting the states with a massive black out, and then throwing your whole military at them... yeah, that's guna roll right over them until they get their shit together. That would be when the stalemates happen, and we're not at that point yet.
As for the Russians being fools, yes, I agree with you here. Nazi's have been overdone, and gaming is looking for a new common enemy, and with Islamic terrorists still being a bit risky to portray, and North Korea being mentally unstable, Russia seems the logical choice.
And for the rest of the storyline? I'm mixed. The first game was brilliant, not too unbelievable, but still with that tense war film feeling to it. The second was a huge shift in mood, that took a lot of liberties and asked the player to forgive a lot more, while trying to make things a bit more exciting and Jame's Bondish. If your the kind of person who reads deep into everything, as I'm thinking you are Brandon, then I honestly don't blame you for feeling this way. Hell, I could see the stories holes while I was playing, but I forgave it, because it was so tense and exciting, and at least the underlying motivations were understandable.
Modern Warfare is a finely made series of shooters with a good story line, and I can't wait for Modern Warfare 3.
Speaking of Modern Warfare... I'm playing Bad Company 2 :) Which is pretty much just MW with the Three Stooges.
I'm a little confused over it though, as it seems to drop some serious sci-fi vibes into it, but never makes much use of them... current level, I'm riding an ATV around a bleached white desert, with WW2 era cargo ships half buried in the sand, looking for a part of a Japanese super weapon.
If that's not something out of X-Files, or Lost... but it just drops it all :/ tries to keep it a light hearted war story with hilarious bickering, and the main objective being saving apple pie and the Dallas Cowboy's Cheerleaders, while going fishing.