my intuition is that novel writing is one of humanity's greatest art forms, and that it would take something remarkable to allow multiple people to be able to do it well together. I can't even think of any novels written by two people that don't suck.
there are good D&D campaigns, but they are written by authors ahead of time.