Instead of calling the next game Red Dead Redemption 3 and forcing another sad protagonist death at the end, Rockstar should drop "Redemption" and call it Red Dead Revolution.
1 and 2 were about dying for redemption, while this one would be about brotherhood, survival, and the Van der Linde gang’s actual Robin Hood glory days—spanning from the post-Civil War frontier in 1870 all the way up to 1899.
Here is how it could work:
GTA 5-style 4-character switching: You play as the core four—Dutch, Hosea, Arthur, and John. Imagine running massive multi-stage heists in real time where Hosea is pulling a distraction, Dutch is talking his way inside, Arthur is covering from a roof, and John is with Dutch for gun support. Constantly Switching between these characters mid heist just like GTA 5
The Robin Hood Era: We always hear in RDR2 about how they used to rob the rich and give to the poor, helping common folks and marginalized people against corrupt rail barons and the government. We finally get to play that era before greed and paranoia ruined Dutch, while slowly watching Micah joining the gang and getting close to Dutch later in the story.
The Blackwater Finale: The final mission splits into two simultaneous operations. You switch between Arthur and Hosea running their real estate scam in town, and Dutch and John getting ambushed on the ferry. Right at the climax on the boat, the game gives you a perspective choice: either play as Dutch and pull the trigger on that girl on the ferry (Heidi McCourt), or play as a wounded John and watch in horror as your father figure kills an innocent girl and watch the turning point of Dutch.
The Endgame & Map: They lose Mac and Davey in the escape, flee into the Grizzlies, and settle into Colter, leading straight into RDR2. In post-game free roam, you only play as Arthur (since John is currently having fun with the wolves lol). Just like New Austin unlocked for John in RDR2, the whole RDR2 eastern map plus New Austin unlocks for a healthy Arthur to explore except Blackwater, which stays locked down with Pinkertons.
Instead of another depressing ending, you get the triumph of surviving against impossible odds and keeping the core family alive, while still setting up the exact tragedy of RDR2.