They can be used to load simple assets like custom skins or a single weapon, different from standard mods.
Require scripts refer to small pieces of code used in a variety of in-game applications.
Require script executor has a rather simple purpose: to let you load up and run any custom scripts for ROBLOX.