As someone who has spent probably the most time in recent seasons listening to goal horns, I dislike most of them for a variety of reasons. The ones I like have a horn or initial attention-catching element and then a clip of a relevant song, and they last about 12 seconds. They're easy enough to put together in Audacity if one has the time to spend making adjustments.

Good examples are Buffalo and LA.