If it wasn't for laws stating "horns should only be used in emergencies", I really wouldn't mind a softer "caution" horn... although it'd get abused and annoying.

Trams in e.g. Amsterdam have it, single bell 'ding' for caution, 'ring' for "get the fr*dge out the way now"