Those Loom comparisons between EGA and VGA are cool. Very impressive work that they did back then. It really highlights how much 16 color palettes forced artists toward simplified cartoon or comic-like representations yet adding just a couple hundred colors enabled the best artists to evoke almost photographic dimensionality, texture and lighting effects.

If you haven't seen it, you might find this site useful. https://en.wikipedia.org/wiki/List_of_color_palettes. I use it as a reference when I'm exploring original retro pixel art from various platforms.