It is important also to understand, that we do not see the same, that we may perceive colors differently from each other, and even differently in different emotional states, and thus perception of a given color is not static (we don't see it the same).
This point is also well presented by Beau Lotto (check out his TED talk).
There is a nice documentary on how we see colors by BBC: "Do you see what I see", which I strongly recommend.
To be useful all those palettes need to become LUTs. There is software, which can generate a LUT based on a color palette or even on a reference image (among other things). I don't think I can post links here (and diclaimer: I'm the developer), but you can find more information on reddit ( r/L_U_T/ )