I disagree very much with the second part of your statement, because it absolutely depends on the game and settings available. Deathloop looks awful with FSR at any setting beyond ultra quality, and even ultra quality looks a bit soft. In motion, though, I'm hard pressed to see much of a difference between any of the modes on DLSS or FSR -- at least in fast motion and actually playing a game like Back 4 Blood. Maybe "in motion" in Myst, you might be able to determine which mode is running. Also, testing at 4K (which is what I used for this piece) is really a best-case scenario. DLSS and FSR at 1080p tend to have far more noticeable artifacting. There's basically a minimum amount of detail you need to get a good upscaling result, and when you start at less than 1080p, there's simply a lack of data.
Let me also note that CAS (FidelityFX Contrast Aware Sharpening) tends to look quite good to me. Unfortunately, for a lot of games with DLSS and/or FSR support, enabling DLSS/FSR disables CAS, which reduces the sharpness you'd normally get. In those games, you can often get a more pleasing overall look with temporal upscaling (like 90% resolution) and CAS than you'd get with FSR/DLSS and no CAS.