A 4070 Super is an expensive and powerful card, though, so that's not a very good sample. DLSS 4 is more for lower end cards, like a 4060, and only on games with bad optimization (which tend to use in house engines, rather than something like UE5).
Hell, graphics haven't even improved all that much since my old 2070 days, and yet somehow it can't even run half of the new releases at 1440p. Some of that are those expenses special effects (which you can't always disable) but some of that is just really shit optimization.