What exactly *is* Custom Content? How can I add it to my game and create it?

I've seen various YouTubers use CC before, but they never explained how it's any different from Gallery items or mods. What is the difference between the three? How can I add CC to my own games, or de...