Is there some way to find out if a vector world location is inside a collision box?

The BoxCollision component has functions named IsOverlappingComponent and GetOverlappingComponents. If your sound generator Actor has a collision component, it could be used for testing if the box is overlapping it.
Also, there are the same functions aimed for Actors, instead of components. IsOverlappingActor and GetOverlappingActors.