There is a big difference between a steam whistle and a diesel horn, especially at 2:30 a.m. I'm not sure I'd like a steam whistle in the middle of the night.
I will say this, however. If you listen to old recordings or films of trains, the enginemen blow plain blasts, without any fancy tails, for the most part. Pedestrians and residents complained about the noise. Towns and cities banned whistle-blowing and fined railroads for violating their ordinances. Railroad rulebooks included language proscribing excessive whistle-blowing. The locomotive whistle was a tool and had its uses. So it remains today.