What exactly does pickup height effect as far as tone is concerned?
It just affects volume, really.
Like stated above, it changes the volume of the different strings. If you make it higher to the low E, the low strings will be more prominent than the higher strings.
If the pickup is too close the tone will be muddy, too far and it'll sound weak.