Bach's compositions do seem to work well in almost any instrumentation.

I believe this is because he was a composer/performer on pianoforte, not to mention his "big ears".

...and at other times is off a little, like a D note played over a C major chord.

This sound is so "key centered" (to me) that it is not at all "off" [crossthreading], but I know what you meant!