> A few cars (Acura comes to mind), do a bit better, in that they have a very soft, more pleasant beep instead of honking the horn

Pretty much all the European cars and luxury cars only use the horn on repeated lock button press and have a chirp for first/routine lock/unlock.

It's really the economy cars that primarily use the horn (presumably for the cost savings of not having a separate lock confirmation chirper)