The guitarist was part of Hitsville USA’s in-house – though largely anonymous – band that provided the music behind scores of hit singles