I love when people bringing DLSS up like we're still talking about a handheld PC here.
Honestly, resolution discussion aside, what do people exactly expect here to happen? That you get a free accessible side menu option of having DLSS available for everything you play and you can manually use it by your choice?
We are still talking about a console here.
The way it will work is, yes it will be capable of DLSS, but games need to have this build in and be optimized for it.
It will not be a "it's there, it will work" solution for all games, there will be games that doesn't use it and then there will be games that use it but still look terrible cause the devs decided to use DLSS performance instead of quality. And then there will be games where it upscales from so low that it will still look bad. I don't think we will have any choice here and will have to deal with what the devs select for the games, which can look better, or worse and I absolutely also expect some games to simply not use it at all, just like current PS5 or SX console games simply don't use all possibilities all the time.
Any games ported to this system will likely have an efficient use of these tools because they know everyone can use them and the exact configuration. The reason people are excited is to finally see a truly standard spec method for its implementation. Some may be overselling it, but most people who buy a Switch 2 will likely do so for indies and exclusives, and any high effort exclusives will likely use all the available tools. Shoddy ports, who knows? At least the tools to make a proper version may be better this time, but you still have to have careful configuration while making the game.
Resolution was a big sore spot with the original Switch, I think people just hope it's a lot better this time because special implementations are actually in place for that now.