Spoiler...somewhat
I'd like to mention a good mod that improves upon the horn. It makes the horn far more useful later in the game imho, and corrects other issues with it. This can all be found in the associated readme file.
http://home.earthlink.net/~cirerrek/