This is especially true for sleep since we can be pretty good at incorporating external sounds into our dreams. It's been shown in controlled experiments. Seems likely that certain noises are generically easier to integrate into dreams than other noises, which could just cause you to wake up or have your sleep otherwise impaired.