The spin-ladder and spin-chain system (La,Y,Sr,Ca)14Cu24O41: Electronic phases, charge and spin dynamics