Not comparing at all because I've never played either, but if Final Fantasy whatever MMO can remake within life cycle and become one of the best FF games, then Cyberpunk should have a long life and chance to fix themselves for PS4/XBO, no?
Also hearing Witcher 3 didn't have a great launch, although I presume much less severe.
The thing with Witcher 3 is that by the time Witcher 3 came out, the Xbox One and PS4 were up to date too.
So CD Projekt Red were able to optimize it bit by bit from okay ish to good.
They didnt have to start at a horrible state, the game wasnt way too much to handle for the old consoles.
They 'just' had to tweak bits and pieces here and there to get to a decent result.
Now Cyberpunk on PS4 / Xbox One vs PC is pretty much a different release
in terms of vision quality. It is impossible to bring those features on the base consoles
and CD Projekt Red is already on the lowest settings possible,
like low low PC settings + a dynamic resolution that goes down to 720p or even less
and it still cant even keep 30 fps. We are talking about drops down to 12-19 fps a lot of times.
This is not something you can magically optimize and suddenly you have a 1080p resolution
and stable 30 fps. I dont see that much hope for base consoles when the starting point is already
that low and yet it still performs horribly.