I think this description of Destiny and other online co-op games like it is what has always drawn me away from playing them. I’ve just never been interested in using online multiplayer primarily as a vessel for social experiences. I certainly have my games that I play with friends (recently PuBG and Overwatch), but they’ve always been centered around a team-based competition. The joy of besting other human beings has always seemed more satisfying than besting an AI which has been deliberately programmed to provide the illusion of competition. (In other words, the AI could beat us 10/10 times if the programmers wanted it to, but that’s poor game design.)
In competition, there is always a clock ticking down to when the current match will end and the next will begin. It doesn’t matter if we’re crushing our opponents or getting crushed ourselves, because the next match is right around the corner. In contrast, online co-op games only end when the objective is met, making the least skilled player an impediment to everyone else’s progress. The nature of these online co-op missions usually means that one player is often carrying the other one, and I’ve always found that to be un-enjoyable regardless of if I’m the carrier or the one being carried.
I really enjoy the social experience of local co-op games like a Super Mario 3D World, because there is the additional context of being in the same room as the people I’m playing with, and we can always go do something else if we get bored of the game. Additionally, that game comes with the premise that all challenges can be reasonably completed by a single player, and the co-op is mostly there to introduce the usual shenanigans that arise from humans being flawed and unpredictable creatures.