DLSS (in its original AA/upscaling definition) is amazing. It looks infinitely better than whatever internal scaling your monitor can do. It gave us back something we lost in the transition away from CRTs, which is the ability to play games at something other than your monitor's native resolution.
Frame gen is more of a mixed bag, I tend to think of it as a motion smoothing effect rather than "free performance". It's only useful in a narrow range of scenarios. The marketing of "Turn 20 fps into 120 fps with 6x frame gen" is BS.
Now this new stuff sounds like AI content generation, i.e. slop, meaning it's totally useless.
I thought DLSS helped on Cyberpunk 2077 but didn't do a damned thing for STALKER2.
However I came to the conclusion years ago that graphics don't matter.
The most damning evidence came when I played Mass Effect Andromeda, the Mass Effect trilogy is beloved for many reasons and it's not necessarily the graphics (which were bad and highly consolidated even for 2007) however it had a story, an atmosphere, likeable characters and above all else, good gameplay. So good the gameplay still largely stands up today without mods. Mass Effect Andromeda had eye meltingly good graphics but everything else about the game sucked. The weapons were underpowered, enemies were bullet sponges, too much pointless running about/collecting... however that could be fixed with mods and it revealed that underneath all that were bland, unlikeable characters, a cliched and unimaginative story that dragged on for way too long, boring sidequests and far too many unmarked scavenger hunts. The graphics were phenomenal for 2020 but the gameplay would have been horrible for the late 90s and the story and characters were so design by committee that the game as well have been called Bland McBlandface in the I Don't Want Upset White Middle-Class Manchildren.
Hence I've come to the conclusion that graphics don't matter.
Now I'm a PC gamer so this kind of AI slop is not for us, it's for the console gamers. Consoles have been more expensive than gaming PCs for years now, the difference being that you paid for the hardware up front with a PC and then the savings started in earnest. A console sold you hardware at below cost but then charged you for everything as much as they could. With new consoles approaching the price of an entry level gaming laptop (the new Playstation is £700, you can get an ACER laptop with a RTX5050 for £650). It's just a new way to lock something else away behind a paywall and get console peasants to pay for something PC gamers take for granted, consoles have always lagged behind PCs on graphics (everything really) but now they're not just going to lag, they're going to pay for it.