APEX-CHAMP(+) high-J CO observations of low-mass young stellar objects II. Distribution and origin of warm molecular gas