thanks!
at the risk of being obvious about a thing, you may already know, that there are freely available palettes for pretty much every major game console, if you are trying to emulate a specific look (i really love the master system palette, https://segaretro.org/Palette )
You can further look up the technical limitations. For example, a SNES games base resolution is 256x224, and while it had a color range of 32000+ colors, no single sprite could have more than 16 (technically 15, as one pixel was reserved for transparency). Lots of good detail out there for any kind of hyper specific retro project.
For the ZX spectrum style project I shelved i was having a horrendous time, but a lot of good practice making readable art, because of its strict limitations (https://en.wikipedia.org/wiki/ZX_Spectrum_graphic_modes). Even worse was trying to make an attribute clash shader.
i see that this is growing ever longer with my nerd interest info dumping so i'll stop here lol.