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.