Just wondering if the main campaign is going to be explicitly single-player only -- and if so, if the modding tools will allow for the creation of a proper co-op campaign for the entire game? Is this even something anyone else is interested in?

The main campaign is going to be explicitly single-player only, yes. Would you really enjoy it with a friend tagging along the entire way?