I've never played a CDPR game before (except for the time I tried to play The Witcher 1, but keyboard and mouse just aren't my thing), and I can say that Cyberpunk 2077, in all my years of playing RPGs, is a great experience: great music, great world, great plot, great acting, great quests, it has it all!
Playing this Resident Evil is revisiting the golden age of survival horror, where everything was new and exciting, with very well crafted stories for the time. I totally recommend buying it if you want to know what survival horror was like when it started or simply because you want a good shot of nostalgia.