I don't know if SONY implementation of CB was often used in later games last gen, to be honest. What I do know is that SONY wanted to make it as easy as possible for devs to implement, and that's why they shipped PS4 Pro with specific hardware for CB. The technique is possible on other consoles or PC using the shaders, but apparently it takes more time and is more difficult to get good results (or that's what I've read, I'm no expert). I don't know is CB the way was meant to be implemented on Pro gives better or worse results than other implementations like those we've seen in Resident Evil 2 Remake, Sekiro or Devil May Cry 5, but I think games like Horizon Zero Dawn, God of War or Detroit have an excellent IQ (similar to native 1800p using much fewer pixels, as proven by Digital Foundry when they analysed Detroid for PC). And of course other reconstruction techniques like Insomniac's Temporal Injection give great IQ and don't produce those CB artifacts in hair and fine objects that some people find so annoying.
But it's true that CB this last gen has been a little bit inconsistent. We've seen very low quality implementations like FFXV or Red Dead Redemption 2, but we've also seen excellent implementations of CB in most first party titles that use it or games like Sekiro, which is 1800p CB on Pro and native 1800p on One X and both look almost identical (and came as a big surprise to me, to be honest, because last From game I had seen -Bloodborne- has a terrible IQ even though it's native 1080p and doesn't even use any reconstruction technique).