If you like hardware:
Yamaha Ex5r (has a VL1m engine, monophonic) or VL series (one or two voices)
Korg Karma/Triton with a MOSS expansion (6 voices), Z1 (12 or 18 voices) or Prophecy (monophonic)
Basically anything that uses Physical Modeling will produce *VERY* realistic brass and horns.
I use a Karma+MOSS (6 voices) and myEx5r's VL engine for horns. Its very good. :D
There is also the Technics WSA-1, but that one uses samples as the starting point and is dubbed "Acoustic Modeling" which isn't the same, nor as good.