A payload is the main thing being transported, whether it is for an email or a space shuttle, and in cybersecurity, often refers to running something malicious, like Shells.
Staged payloads contain multiple levels to setup other parts of the payload, while stageless payloads run directly.
Metasploit is useful for creating and delivering payloads.