Um... Why would he even be using a gun for putting a hole in the wall. Silly human.
It can be pretty effective.

This is what my cap and ball revolver did to a 50mm plank at the shooting range.
Perfect round hole at the front..

Eh, maybe not so nice after all.

