If told
exactly how to play, a robot or a computer
can reproduce the musicianship of the programmer. They can be useful tools for research, for finding out how we play and what we like, but the time spent in pasting and programming together the perfect performance may exceed the time and effort expended using "real" musicians.
As for samples, check these guys out:
Vienna Symphonic Library
Have fun, and don't give up the trumpet just yet!