Absolutely but it depends on what kind of DLSS we're talking about, since nvidia uses the term to talk about multiple very different technologies. DLSS framegen can make things look smoother but increases latency and introduces visual artifacts. I would never turn it on for something like a first-person shooter, but I could maybe see myself using it in a game like Civ VII where a few extra milliseconds of latency isn't a big deal.

The really important one though is DLSS upscaling. Back in the day if you ran a game at lower resolution (usually for performance reasons) and upscaled it it would look like shit. DLSS upscaling lets you do that and have it look almost as good as rendering it natively, as long as you don't push it too far. It didn't work super well when it was first released, but these days it looks great and can really improve performance.

The benefits of DLSS yassification are questionable.

DLSS, FSR, XeSS, etc are all great for extending the life of older cards. Unfortunately, the GPU manufacturers found this out pretty early on and keep updating the technology to be more and more performance expensive, meaning you need a newer card to get any benefit.

Therefore no, the new versions are not really worth anything other than artificially boosting your framerate, which at that point just dropping the render resolution will probably give you more or less the same result.