Yeah, I'd say nothing about this is as simple as "what's best" for comparison.
Some may have far superior sounds, but be mind boggling and difficult to use. And the prices of some of these things is quite prohibitive for the hobbyist.
Some win the trifecta. Difficult to use, sound great and are really expensive.
And there's always the fourth variable. You might not agree or align with what I personally feel sounds good. Or is too difficult to use. Or is priced a bit high for me.
I think its a good idea to ask what others use, and demo them for your self. I am always looking for things that sound good to me, have an interface I find fits my workflow (Generally that means "simple") and doesnt make my accountant anxious.....
And for this hobbyist, that usually means, "sounds passable" "Dirt simple to use" and "Cheap/free"
But I can share that I have also found, use or want some that fail at least one of those tests.
Since you mentioned specifically orchestral, I would add to Chibears fine list perhaps what I would call a "happy medium" that has a vast library of quality sounds, and acceptably useful interface and while certainly not cheap, isn't in the "upper tier" either. Pretty flexible and broad package. IKMultimedia Sampletank is IMO worth considering. It may or may not be a fit for you. I don't think it offers the detailed accuracy of some of the stuff Chibear mentions, and on the other hand, its probably overkill if you just want to create string pads or background horn parts etc.
Hard to gauge your needs. Its probably not what the beginner starting out needs either though.
Learn to use what you have well, and your specific needs will likely become clearer over time. Try to avoid filling up your computer with stuff you end up not using. (If that's even possible