RDR 2 was one of the best games ever made and the story and side missions were incredible.
KOTOR story wise still wins it for me - Never saw the twist coming and was just brilliant.
I would love a RDR 3, but I seriously doubt it will happen.
GTA 6 will just make RockStar too much money and they will just monetise the online element for years after that, so even if they did want to do a RDR 3 development wouldn't start till 2/3 years after GTA 6 is released.
As much as I like GTA, it isn't as good as RDR 2 - Just gutted never played the original RDR as playing it now, the controls and everything feel incredibly dated.