I bought some G9 bulbs, and they are not performing like the halogens... It doesn't give me the full RGB like halogens and my house looks pale white(lacks red) instead of full color. I might go back, I do not like the look of my house, and I find myself turning on my living room lights AND dining room lights. The brightness wasn't there. There is massive improvement to be made on LEDs still.
G9 is probably quite challenging for high-performance LEDs because the size is so small. In the other sockets like E27 and GU10 there are lot of options available and also products designed for commercial use (where you need certain characteristics because you want to make your products look good under the light).