What makes a great riff or solo, and how does the keyboard player fit in a band? From purveyors of excess to cool minimalism, rock or prog to soul, electronica, postpunk, pop, jazz or classical, synth to clavinet, let’s follow those fingers