The object that "cuts a hole" into the drawing canvas, must have the blend mode "destination out" set on it.
When you set this, it won't always look how you're expecting in layout view, but once you paste, it will do exactly what you hope.
If you still need a visual sprite to show the area you're about to make a hole, then I'd suggest 2 sprites, one with destination out, one without. (you could do 1 sprite and "set blend mode to destination out, paste, set blend mode to Normal, but it will change it's appearance during the paste).
If you used many layers with Force Own Texture, just for this hole system, you may not need all of this - even 1 layer, without Force Texture, will still punch a hole when you paste a Destination Out sprite.
Hope this helps!