RDR 2 is too linear for me and what it really lacks that I love is diversity of story outcomes based on choices. That is not a Rockstar staple as they are clearly telling a singular story as intended, similar to say something like a lot of Final Fantasy games. But despite this, I get into their characters and I think they write them well enough to get the player invested into their lives and you really feel the impact of Arthur's story and John/Jack etc. I'd kill to be able to have a small possibility of changing Arthur's fate based on specific choices but I understand that is not the vision of this franchise and enjoy it for what it delivers.
I loved Witcher 3 too but a major reason I am excited for CP2077 over Witcher is being able to create your own character. For me personally, it is much easier for me to immediately feel like I am playing my own story and choosing my own ultimate destiny versus Character A's story, etc. BY FAR for me the most immersive thing of all (even over all the TPP/FPP debates) for me is the feeling that I am my own character with my own backstory/attitude in my mind, and that I have player agency to actually choose and impact my own future and that of other characters you come to love/hate/not care about/etc while you play.