I nearly passed out from adrenaline rush the first time I did Starcraft in MP.
To this day, the
excitement is mostly in MP gaming. The obvious exceptions are really beautiful settings/stories like Bioshock, Fallout1/2/3, Dreamfall, etc. I still do tons of SP gaming, but I find it more relaxing, more meditative. I like being able to take my time sometimes. Get up and get food or otherwise tend to the body, without worrying about inconveniencing someone else, that sort of thing.
I guess my point is, both are important to your diet. It's like MP is meat and SP is vegetables, most people require some of both to survive, with a relative balance based on personal tastes.
Oh and that said, I was also under the impression that the new IW project had a heavier SP emphasis. But that could be totally off-base. In actuality, maybe it will end up something like Warlords as far as gameplay goes, though maybe with extra depth in your "heroes", however that all works. Either way, I'm excited for it, because despite what Dominions lacks from having such a small team, what it has are some of the most important things to my gaming enjoyment.