The only way DLC is worthwhile to me is when it feels like it's adding something that the main game didn't have AND the main game's gameplay formula still has more life left in it to explore.
DLC for Team Ninja's games is usually great because they add new mechanics and make old ones more consequential. Fallout 3's DLCs were great, with the level cap increases, new perks, and continuation of the main story.
By contrast even if Elden Ring adds DLC I'm not sure if I'll play it. It'll just feel like there's a new area in the game that I didn't explore before. That's how their DLC has always felt. More of the same when the game was already huge.
Cyberpunk 2077 is one game I'm looking for to the DLC for--I hope it adds significant new mechanics and not just a story, but it's a great example of "gameplay that still has more life." I finished it but didn't even get halfway to level cap and didn't mess with a lot of mechanics. Plus they could easily increase the level cap.