Honestly downvote me if you will but i thought it was just ok. Depending on what you like about the game.
Story = Good. it expands on background characters in the lore, but still leaves you with questions.
New weapons = Decent. they are fun to goof around with, but not that great to use seriously. I only really liked the tracers, dual wield daggers with a cool moveset.
New spells = Pretty good. they do feel similar to original sorcery spells, but they have little tweaks to make them a bit different. The new pyromancy is just a recolored combustion though.
Boss fights = Excellent. artorias is maybe the best boss in the game? and the other bosses are very good too.
Exploration = Poor. Since this is my favorite part of dark souls, I wasnt that impressed with the dlc. You get 3 areas that are a bit too similar to original dark souls areas and are not very large. There's darkroot garden 2.0, undead burg 2.0, and tomb of the giants 2.0.
Combat (against normal enemies) = Also poor. There are 5 enemy types which are not very exciting. Dogs, tree guys, stone giants, zombies, zombie casters, and spirits. The casters are the only enemies that are kind of tough, and spirits are nearly harmless, while the rest are pretty similar to enemies from the original game.