The Breath of the Wild's DLC falls into both categories. I both feel that the game should have included most of the DLC content from the start AND that I'm glad that it came out later to give me an excuse to dive back into the game. The same is true for Horizon: Zero Dawn. It's DLC was absolutely amazing and certainly added to my love of the game; however, it felt like it should have been part of the game from the start (although, I feel that its quests were better than the quests from the main game). Now that I think about it, I haven't even finished Skyrim's Dragonborne DLC; however, I bought that as part of a packaged whole with the game. Nor have I played the DLC from The Last of Us--even though that's been high on my list.
Meanwhile, Starcraft II--which is one of my longest played games--charges entirely too much for its DLC of guest voices, vehicle skins, and (what really burns me) co-op commanders. I play the co-op game with Trevor with the commanders that have been unlocked so far, but I find the price of the "locked" commanders outrageous considering the limited play options of the co-op portion of the game. One thing that I liked about Overwatch (although I have kept to my cold-turkey stop on that game) is that all DLC was either completely free or part of unlockable challenges (although people could opt to pay extra for chances at special cosmetic changes to the game).
I know that the video game business is, in the end, a business and that they will continually look for new ways to monetize. I suppose that I can chose to show my support or lack of it through the voting power of my wallet.