There are many great libraries on the market, the trick is to choose them depending on the context (Music style, tempo, etc.). I highly recommend CineBrass Core + Pro and maybe layer them with Caspian.
Caspian isn’t the best library, but it has a very fast attack, and combined with CineSamples, it could help you get the typical “fanfare” sound. You’ll need to match the ambience the rooms and tweak the note length to match the endings of the CineSamples’s, of course.
THOUGHTS ON NOTE PERFORMER
Note Performer is nice to get a general idea of the sound when you work with live players, but by no means useful if you want to get a realistic result.
Every VST library is unique, the legato speed and scripting works differently, the dynamics are different, etc. so you have to manually play-in every part in a DAW to get a realistic performance instead of notation software playback or MDI export. You need to manually shape the dynamics using the modulation (CC1), adjust the phrasing intention with the expression (CC11) as well as track MIDI delay to make sure the phrasing timing is correct.
I absolutely love Berlin Woodwinds by Orchestral Tools because it comes with different players so you can have an actual Flute 1, Flute 2, Flute 3 for example and have realistic divisi sections. It’s pricey but really worth it.
For the master Reverb it’s usually it’s a separate FX track with a concert hall setting to which you send your signal to ‘glue’ the mix together.