I'm not sure if I'm alone on this, but personally as much as I love John, I would not be a fan of Arthur dying and then playing as John. The first issue is that it is very predictable and nobody would be suprised if Arthur died. Maybe Arthur dying would work in some way, but if it's by John killing him as many are suggesting, I would only like John less. Of course John wouldn't have much of a choice, but it still would make me like him less for killing a character I'll be bonding with. It's been stated that "However, it is revealed that Arthur is going through an "existential crisis", where he begins to develop skepticism regarding Dutch's ideologies and motives as the gang grow more notorious in status over time."
Now here's where I just get into theorizing and sh*t. Because this game is starting at the 'downfall' of the gang, I think it's reasonable to believe that the game will have the part where John Marston is left by the gang. Because of the statement above, I believe that throughout the course of the game Arthur will be straying farther from the group. I can see both of them being left behind or at the very least Arthur not wanting to leave John behind. Now I'm just rambling. I don't know, it just makes sense for Arthur to help John and for John to in turn help Arthur and (possibly Sadie) to stay off of the governments radar or fake their death or whatever so the government and Dutch won't be able to find them. Just a theory. But personally, with what we know so far I'd in turn like for a peaceful ending with John and another girl from the group (maybe there is the option of making relationships) living out the last of their days in some mountainside Cabin or something