Yeah, the crux of the issue is that it really was more of a Next-gen game that they tried to pass off as a functional game on last-gen hardware. Even now, I don't think there's a native version for next-gen hardware, but once there is, I assume most of the problems will go away. Most of the issues I'd wager, stem from the game engine not getting sufficient resources to properly function. And by releasing early, they got into a situation where most of their playerbase were on older hardware. But they likely had known and should have made a better effort to have it play better on that hardware. I heard that their main version was the PC version, which makes sense as that's they were most used to, and that console versions of Witcher 2 on XBox had terrible performance issues as well, to the point that some have called Witcher 3 a fluke. So, they did have a history of poor console performance before Witcher 3.
The Witcher 3 was a trainwreck when they released it and they had to do a lot of work to make it playable on consoles. I got the Game of the Year edition, but would've been pissed if I had bought the game day one.
Listening to an interview the other day, they make it sound like they were trying something new in Cyberpunk 2077 by streaming in assets as the game progressed. Which sounds like something where an SSD would be needed vs. a mechanical HDD. I wonder if a base console with an SSD would have better luck running the game?