I found this interesting, a detailed (and canon based) look at the history of the Borg. It doesn't detail what happens to the collective though (as the series never went into that)