RX100: where' the macro button?

Main reason I don't like it for macro is that you need to use the widest zoom setting which gives you bizarre perspective close up. Secondly, like you say, you need to stop down the aperture considerably before you get acceptable IQ. Other compacts I've used do not have these limitations.