This is a tough one. In overall, Canon G1X is better for general photography, but Sony RX100 is more versatile (macro, sweep panorama, faster shooting).
BUT because macro is one of your priorities, I recommend the Sony RX100. Canon G1X is NOT for macro shooting. If we forget about macro, Canon G1X would be a slightly better choice because its bulkier size is not a problem for you.
Some tests:
http://www.digitalrev.com/article/sony-cyber-shot-dsc-rx100/MjkwODM1ODE_A
http://www.imaging-resource.com/PRODS/sony-rx100/sony-rx100A.HTM
http://www.cameradebate.com/2012/sony-cyber-shot-dsc-rx100-review/ (see bottom)
http://digital-photography-school.com/canon-powershot-g1x-reivew


