As the others have pointed out, DimPro is the best option in Cakewalk for natural, acoustic sounds (it does weird, too).
However, it sounds like you are used to GM sounds - that is, General Midi. The files you are finding on the internet or where ever are probably meant to be used w/ this format. In the early days of soundcards they included sampled instrument sounds, and developers came up w/ GM, so that a midi file could tell any soundcard to play this instrument w/ these midi notes. This info is part of the midi file and happens before the first note.
Piano is one, midi channel 10 is for drums, etc. etc. GM is a mapping convention so any of these 2nd generation, sample cards could play standard midi files. We've kept it all the way to today. And surprise, TTS is the only GM synth in the Cake arsenal. It should sound better than the better spec'ed DimPro is that it plays the piano for the piano part, rather than a tuba.
Other than the "effects" problem you are having, simply "insert" an instance of Dimpro (or synth of your choice) into a channel. If you aren't playing it but using GM midi files it will be a mess, since the GM is spitting out all the music parts on 16 midi channels while DimPro is playing all those notes on one preset. You'll have to edit the GM file down to single channels and assign each channel to a separate instance of DimPro. And find the proper sound for it. A lot of work, tho you can learn a lot if you are experimenting.
Basically, if I am following you, the problem lies not in the synth, but in the midi files you are using.
@