Add BP's for foliage meshes to add trigger sounds?

You could use
://mosthostla/gamedev/dynofoliage

And just add a sound to the replacement blueprint.
I’ll add native support for this in the next update.

Anyway, in the tutorials you can find some info on custom trace channels, which may help if you go with the physical material system.