How to make hole in wall in real time

Hmm, sounds indeed as a perfect match for BSP…

Maybe you could use a translucent material and set the alpha to 0 on the right place through a dynamic material or something…?