I used to have a macro lens, and while I quite enjoyed it, I found that since I primarily do wildlife photography I could use a longer focal length telephoto lens at distance to get nearly as much detail by filling the frame with the subject. I have quite a few butterfly photos that were taken with a 300mm or 400mm telephoto prime, not a macro lens, and you'd be hard pressed to know the difference.

That's not true of /all/ macro photography, it depends on the specific details of the subject you're most interested in capturing. Without a macro lens you aren't going to capture the subtle textures of a butterflies wing, but you can certainly get a good photo of the entire butterfly including the textures of its eyes without a macro lens.

That said, I love doing proper macro photography. It does require a bit more kit though, you really need a ring light or a dual-flash, and a tripod and focus rail to support doing focus stacking to get extremely detailed shots. Agreed though with your sibling comment that manual focus is fine. There's really no reason to worry about refocusing on a subject once you get initial critical focus, it makes more sense to move the camera/yourself (which is the way a focus rail works).