I have previously pitched this idea to Manhattan (and was denied but here is my pitch again)..

The goal horn is just everyone on the team Mooing. Nothing else. Just MOOOOOOOs very loud all at once and maybe a smidge off key. And then can be ended by a brief and quick Moo by CoA and Canadice.