A few small corrections to the RGB section: it's five LEDs per module, not four.
I'm running a dual channel kit on a Gigabyte GA-AX370-Gaming K5 using static mode and it works (the other ones you cited as not working may also work, but I haven't tested them). The trick is that there's a bug in the software where the LED brightness is turned all the way down by default even though the color wheel shows differently. It's listed under the known issues on the G.Skill forum
There's a bug where the default color has its brightness turned all the way down, even though it shows up as red. So the small circle inside the triangle is not on the lower left corner. And when you change the color by rotating the knob on the color wheel, the brightness value doesn't change. The best way to resolve this (if you are on first install or after clicking on "Default") is to click the red, green, or blue box to the left of the color wheel. Then click the button below the five color group selectors to apply the same color to all groups. After this step, you can move that color wheel to any color you want for any color group without the brightness issue. (Note: The other lighting effects, like comet and flash and dash ignores that brightness value, so that color bug doesn't affect those lighting effects.)
http://www.gskill.us/forum/showthread.php?s=e7362d5bdfbea3f1fd8fbcb5cb066d37&t=14257