For example, the 'click' of a door being opened may simply serve to convince the audience that the image portrayed is real, and the audience may only subconsciously note the expected sound.

Even a simple note on my guitar has an array of harmonic frequencies. But the frequencies have a special harmonic relationship, which is why you hear it as a single sound with a single pitch.

But if you mean a note enough, it will sound different.