No. I was looking forward to it a few months ago, and although i'm sure the single player will be great it's the multiplayer aspect which made MW so good (custom maps, mods etc.).
Will wait a while and see how things turn-out, though for now i've got Dragon Age to keep me busy.