I've been living in Japan for the last decade. I still think CP2077 is on the bare edge of what both Microsoft and Sony will allow
Japanese version and Saudi versions were even more censored compared to the American release, which was still last minute censored, but not to the extent the japanese release was.
Going as far as to just turn the screen to black during some of the sex scenes.
A couple YouTube videos have done side by side comparisons on the regional censored releases.
But your point on Sony does seem to be right, as in a previous post, it was confirmed that Sony was the reason the game was so heavily censored in Japan, they refused to release the game unless certain censorship took place with their release.
It looks like Sony's demands bleed through to the international release, as they last minute patched it to add additional censorship to all regions, so that the game could be released on PS