My experience with DLSS has been fairly positive in terms of performance and it looks better than TAA, but definitely not as sharp as MSAA. It also manages to get rid of some specular artifacts that MSAA can’t (though it is fairly rare and you can design around it). Generally I think it is viable to offer as an option, depending on what the player wants.
It comes with a couple of weaknesses. You definitely can notice artifacts around some edges, when you focus on them, for example aiming through iron sights. Also some dark scene’s where there wasn’t much information in the image, had significantly more ghosting. It also has problems with small details that do not generate good velocity data, like chain link fences, laser beams, etc and transparent surfaces can also cause some weirdness.
I also noticed that the DLSS Plugin doesn’t play well with OpenXR for some reason, but I’m not 100% sure if it is really that, but my issues with OpenXR started with the DLSS Plugin. At some point I might look deeper into it, but it looks like it has something to do with problems to obtain the correct resolution?
BTW this German article also seems to have good results with DLSS: Nvidia DLSS: KI-Upscaling mit Raytracing im VR-Test