Running Cyberpunk on a 2080 Super at 1440p ultra settings, with DLSS set to performance, and the tech is some black magic wizardry. I went from frames hovering around the mid 50s, but then dropping suddenly to the 30s and even 20s in busier areas, to now having much more consistency, stability, and even a smooth 60fps in a number of cases. It's truly amazing technology that, in my case, doesn't deteriorate the graphical quality of games that have it.
That being said, I don't believe that it was a, "mistake" for neither console manufacturer to not have an equivalent to DLSS. They, especially Microsoft, waited as long as they could for the most recent technology available, and that's enough. The hardware in both next generation systems will be just fine, more than that, really.