The best is dramatic. But not anybody can do this, because it is hard to write it. In normal situation the best will by lighhearted stories + funny. Action is the best only in multi-player maps (ex. red must kill blue :P). But Coplex is good only with mixing with other types.
So I think, the best story for single player is Drama + Complex