LBP 1 & 2 level/kit DLC are for me excellent.
The DLC costumes are nice extras and are adorable but the level/kit DLC offer great value IMO.
When with the Pirates of the Caribbean DLC MM added water it really expanded the game in a meaningful way.
That is how DLC should be done for me.
All the various LBP DLC kit that added new materials or new item (Paintinator) worked well for me becse I always found a use for them and overall they were fairly priced.
LBP free DLC costumes are unmissable
Dragon's Dogma Dark Arisen is not out yet but from what I read it seems to be doing things right: new areas, new enemies, but also better UI, better fast travel mechanics, more customization option, new abilities, etc..
In short a combination of improvements and addictions.
Now is just a matter of: please be good, please be good...
As for MP DLC for me they are still not done properly: they always fragment/divide the player base, which is not good for me, and in the end are never even as popular as they should have.
DLC maps, modes often end up being wastelands.
Story DLC can be great but none of the story DLC I have really added enough content for me.
Even Lair of the Shadow Broker for me din't work; it was excellent no doubt but really not good enough for me.