I still remember where I was when I first time I saw the piano partitas (BWV 825-830) performed. Gould playing the one in C minor moves me about as much as any music, along with some of the others you mentioned.
Bach's compositions are unquestionably beautiful and technically brilliant, but not all of his music was written to stir an audience. He composed in a different time and for different reasons than the classical composers that came after him.