Is it possible to create holes in cloth at runtime?

You can use Project/Render to texture, and use that texture as opacity mask in material.
For example, Event Point Damage will get you hit position, you’ll apply radius and render that into texture.
I’m 100% there is tutorial but with grass instead. I’m sorry I cannot help you more.