What does the expression "it was the sweet spot between his shoulder blades" mean?

A sweet spot is any spot that is special for any reason. A baseball bat has a spot marked by the label where all the energy of the bat is transferred to the ball and none is reflected into your hand. A cat has a sweet spot between the shoulder blades where he likes to be stroked. (Females don't seem to care.)