Going in, I envisioned the Chalice Dungeons to be something similar to Phantasy Star Online's separately distinct areas of scenery with some more complicated procedural generation. It just seemed like one big bland place that was a giant chore and just didn't hit the mark with me.
The queen's fight is pretty neato. Probably worth the slog through if you have nothing better to do.
I was half expecting the Yharnam Stone to have some effect in the DLC somewhere, but the internetses tells me that it doesn't appear to be the case. Speaking of which... The Old Hunters is on my to-do list. Been waiting for a sale, but I might just have to bite the bullet and grab it. Or - since I have a weird thing about wanting the DLC on a physical copy - grab a Hong Kong version and start over. (Same goes for a PAL version of DS1 Prepare to Die.)