StarCraft: The Destiny Is Unknown is a mod with modified units with abilities similar to StarCraft II and new story which is related with StarCraft II story, new campaign... To play campaign, in game menu go to "play custom" and "CAMPAIGN" folder and select zerg, terran or protoss missions... First version is 1.0 beta which haves only one mission for every race. Newer versions will be with full campaign.
I personally found the storyline to be a bit... Lacking. It was also quite boring, the missions were... Well I will say that they were interesting, the units were fair, but there were a lot of typos and some things a lot of people would not be able to understand. I mean, it is a fairly good mod and you did a good job on editing, but.. I personally think there could be more added to each map and the entire gameplay more interesting. I sorta liked the separate .EXE thing, but you didn't need the entire 600+ MB to do that, there are others who have done the exact same thing with a Self Executing patcher, which I think were less than 10MB each. A lot can be done, I am no modder or expert, it's just what I have seen and my personal opinion.