if you are still hunting...
Session Horns Pro sounds a LOT better, to me, than Session Horns, which I own, but don't use a lot.
Chris Hein Horns is brilliant - I own only the compact version right now, and it does take some time to learn, but the results have been pretty darned good. Certainly better than any of my other attempts. (at this point I think my disappointment comes down to my poor horn chart writing skills!)
Two others I still dig up from time to time:
- Chicago Horns, originally released for the EPS, but it imported nicely into Kontakt. Somewhat limited in terms of samples, and vibe - you're gonna sound like Chicago, but sometimes that's what you want!
- Greg Adam's Big Band Brass - it is a loop library, so again it has some limits, but I do love the sound!
The Greg Adam's library dovetails nicely with Chris Hein's Horns, for what it's worth!
Good luck and happy hunting!