Honestly, the game just seems to be going for obtuse for it's own sake:
The conditions for the extra NPC scene in the Cathedral of the Deep are just moronic. The amount of doubling back through areas you would have no reason to go through, at points you would have no business being there, is just needless and frankly, kind of fucking rude.
There's a similar micro-aggression at the entrance to Irithyll, where to get a scene to progress you have to double back across an area immediately after clearing it. There's no reason you would ever, in the entire game, need to physically go through this area again (there are no enemies, no items, and there are literally bonfires on either end of this completely linear path, in a particularly bizarre choice of placements considering how conservative the levels are with bonfires otherwise, basically guaranteeing that if you ever wanted to go back to the previous area for some reason you would just warp anyway).
I'm pretty sure it's just Miyazaki saying, "You guys like this shit, right? You liked that shitty questline that we didn't really get around to polishing in the first game and everyone in QA complained about, didn't you? Here you go, eat up you dogs."
It's not quite as bad as Dark Souls 2 in that regard, but it definitely feels like someone was consulting a checklist of Things the Internet Said Make Dark Souls Good rather than just putting this together organically.