Basically all graphics post 1985 up to about 92~94 was done on Deluxe Paint in the west. To this day the file format IFF is still used in games. Maya even outputs IFF files.
C64, Spectrum, Amiga, Atari 8bit, Atari ST, PC, Nes, Master system, SNES, MegaDrive, Dragon, Oric et al.
I would say 80% of it would be Deluxe Paint Amiga editions, they were the flagship over the ST versions, as the Amiga had better graphics capabilities. Some artists in the DPaint AGA era preferred Brilliance over DPV. Some like Doom for example was done on Deluxe Paint II pc as they needed 256 colour support before AGA Amigas.
Japan has a special custom program that uses a Parallel port dongle and cost and arm and a leg. Magic System Tec, Image Magic Tec?? something like that, I have/had a broacher for them somewhere. The early versions ran on PC 88/86 so didn't really get over here till it ran on normal windows.
The graphics on the NES at Nintendo seem to have been done mostly on Grid paper, but there are photos of them having one special machine, notable in that it has the screen arranged in landscape like the Xerox Palo Alto. There was some scans a japanese magazine that were translated and shared showing the dev machines and the process it made a huge splash on the net a few years ago.
Rare didn't do pixel art but converted 3d rendered animations and hence yes they ran SGI work stations.
One of the artists I know had a Indigo II under his desk to use a special tile animation program that was just better than anything else. Don't remember the name of it either.