It really boils down to horses for courses. The choice of color temp depends on the predominant color palette in the game. It also must be taken into consideration that (especially in older games), the artists were likely working (including mixing colors) under incandescent lighting, so you’ll see the greatest fidelity to their “vision” by reproducing those conditions with the playfield lighting. For example if you ever seen a BK or Gorgar retrofitted with cool-white LEDs, you know (unless you lack any sense of aesthetics, lol) that it looks washed-out and just ALL WRONG.
If there are lots of blues, purples, whites, and other “cool” colors, then I think a cooler white LED can work better. I don’t think these games look “right” with incandescent lighting; just for fun I once experimented with replacing the stock LEDs with #44s in a section of my ST playfield, and it made the playfield look like it was stained by 40 years of secondhand smoke - gross.
If the game is more red/orange/yellow/green based, the warmer whites and incandescents will make the colors more vibrant. ACDC and Met look better in incandescent than LED, for example.
Simpsons is a subjective case. Incandescent or warm white led is faithful to the way it was designed, but lighting it up with cool white is more consistent with the way the Springfield universe looked on a CRT TV. (I’d lean cool white personally.)