I will never, ever get the obsession with DLSS. It runs on a single manufacturer's cards, and it only serves to increase framerates -- the need for which generally points to other issues with any game.
It is kind of like "true motion" effects on TVs ten years ago. Adding frames for frames' sake.
For some DLSS can mean the difference between an okay experience or a refund. It's a band-aid you put on a badly optimised game, but it works.
Adding frames becomes relevant when you're starting to go below 60 or 30 fps, depending on your taste. And while I don't enjoy it only working on Nvidia cards either, they still have a quasi-monopoly on the GPU market, so I'm glad they're still thinking up new things instead of stagnating.
Depending on the end user though, it isn't just a band-aid. DLSS can help add new life to aging cards and prolong their life for a user that may not be in a position to drop money on a new card.
Not everyone is coming to the table with the latest hot and fresh systems to hit the most technically demanding games and DLSS helps them get those most out of their rigs.
I use it mainly for AA since it gets rid of flickering on things like fences or trees quite well. Especially in games that have otherwise shit AA (I dearly miss the DLSS option in Cities Skylines II which has atrocious AA that flickers a lot).