It's much more fun for a human to win with a small force against seemingly overwhelming number of enemy mooks.

If computer games had awesome AI trying to beat you, you'd need the overwhelming superiority of numbers just to stay alive.

That applies to the computer competing with you, though. There are games, like eg RPGs, with more space for cooperative AI.