That is always a problem, hype, it can make something good feel only okay or worse. I only watched 2 videos on CP2077 in the last month and nothing else over the years so I didn't hype myself for it
Imo CP2077 looks very realistic (texture and lighting wise) but yeah I am able to run very nice settings in RDR2 at 1440p also but I feel CP is on another level to RDR2 with the character animation, detail and over all amount of detail in the world , and such a different world, a city with reflections and angles everywhere.
Our cards are pretty old now so I'm sure they don't even get a look at by big development teams.