Most of From Software's DLC content for the Souls series has been quite good. They always seem to add to it in important ways.
The first DLC for the game, at least based on informatyion from a leak might disappoint those who ignore the PvP part of the game. By way of Hachima ( via Siliconera), a leak says that the DLC will featue a PVP snow map called "Immortal Competition". On top of that, there will be new new weapons and magic to get your hands on too. It is said to be launching October 25th.
While I'm sure many would have been hoping for new area's to explore and bosses to conquer, there is another DLC planned for down the line. Details seem to be flowing on this quite fast, so I will be sure to update when more come in.