SOP's should be used for one reason only.
TO PREVENT AN INCIDENT HAPPENING IN THE FIRST PLACE. Where they are used as an arse covering procedure by airlines then they are very likely to be barstadised to such an extent as to potentially cause the very incident that they are designed to avoid.
Almost exactly what I meant to say. I'll just add that overgrown SOPs are not dangerous per se. They can be so hard to know and follow that crews get demoralized and decide not to follow SOP at all, because they feel it's all rubbish. And when proverbial hits the fan, guess whose nether regions will be well covered and who'll get the blame - posthumously, at the worst.