After re-reading and doing a bit of speculation myself, I think these are very telling statements that were recently revealed.
This is my opinion based on everything that has been stated so far, feel free to disagree.
We now know from this post that the DM did give some sort of a dive plan. I think that it's at this point that the temptation for going deeper may have entered Brendans mind. It was mentioned that he already had a depth goal in mind and this presented an opportunity to go just a little bit deeper.
At this point, when the turn should have been made, Brendan may have either gotten distracted and failed to follow the group, then continued swimming straight thinking they went that way, or he may have conciously made the decision to drop over and go just a bit deeper. Narcosis or disorentation could have played a part in this. ESPECIALLY if he decided to try and do it without anyone noticing and swam hard, causing a build up of C02 and invoking a quicker, harder hit of narcosis, or a "dark narc."
Knowing how quickly the walls in Cayman drop off, its not out of the question for me to think he could have dropped over the side and quickly been out of line of sight for any of the other divers. Even looking over the side of the wall in the daytime, you're staring down into darkness and it can be hard to pick out a diver, or their bubbles that are more than 50' away from you.
It's during this point of the dive that I think the DM had his greatest failing. If I was leading a dive like this, I would have drifted out so that I was further over the wall than the rest of the group and indicated the direction they should continue in. Only once I was assured that all the divers had made the turn correctly and were heading in the right direction would I move back into position to continue leading the dive, checking back frequently to make sure everyone was staying within depth limits.
Once again, this is my speculation of where and how things may have gone wrong based on the newest information.