I went down to the Griot's Garage store, since I'm nearby, and checked out the horns that they have.
The other design, not the Hella ones, are obscenely loud, at least when you're in their garage and they blip one 3 feet away..
http://www.griotsgarage.com/catalog.jsp?&SKU=77839