Either Kontakt or SampleTank would be a good virtual instrument replacement for a keyboard workstation. Those are probably the best available. Then there is always Steinberg HALion Sonic, but while that should work with any DAW, it is optimized for Cubase. So that is about it for the general instrument samplers.
Everything else is very specialized for orchestral libraries, or specific instruments, etc. Big bucks involved in the specialty stuff, as that is the domain of professional film composers and such. The rest of the soft synths are aimed mostly at electronic music producers. There are a few good commercial virtual analog synths, but they won't have the real instruments you are probably seeking for your musical styles.
If the soft synth interfaces aren't working for you, maybe a trip to the local music store might help. Some folks still prefer hardware.