The nature of plasmon excitations in hole-doped cuprate superconductors