I would say single-player is better than co-operative multi, and co-operative is better than competitive.
A good co-op campaign can be just as good as a good single-player campaign, but competitive campaigns don't even exist, so it's just a series of unconnected events where most of the time you do terribly. It's a very rarely competitive multiplayer segment that I like. Tribes Ascend is a good example.







