In his book, The Soft Shoe Diaries, Joe McNally says: "I'd rather have a root canal without anesthesia than do macro photography," and I agree with him.
Macro work generally appeals to the right brained, anal retentive types, that completely lack compositional skills...such as myself.