Most emulators use the "PAL" palette by default, which in fact does look "like ass"... I don't use RetroArch but in modern versions of VICE on the PC you can change it to NTSC and use the "Sony CXA" palette which is how all my C64's look in real life. Actually, I think that palette is the default now if you choose NTSC.