How can I replicate this texture featuring holes in walls that expose
the bricks behind the stone? Should I create it on a trim sheet, utilise
decals, or actually model the broken sections? As I have not attempted
this before, any helpful references or tutorials would be greatly
appreciated.

Thanks

Replies
http://wiki.polycount.com/wiki/MultiTexture#Modulation_Blending
More examples:
http://wiki.polycount.com/wiki/Modular_environments