This is a common mistake that people think that close distance shots need less light. There are several reasons for requiring a lot of light for macro shots:
- When shooting macro, your depth of field is greatly reduced due to the proximity to the subject. To compensate for that, you would often need to close down your aperture quite a lot, letting less light in. When doing so, a powerful light would be needed to properly expose the subject.
- Macro images are much more prone to shaking and every movement could result in a blurry subject. To make sure you get a sharp image, you would need a very fast shutter speed. While shutter speed does not apply to strobes, this is quite important when shooting macro with a video lights and would require more light to expose the subjects.
So the simple answer is No. For macro , you need a lot of light.
That being said, a lower lumen dive light with a narrow beam, can actually concentrate a lot of light on a very small area which could be sufficient for lighting up a small macro subject and prove to be enough for getting good stable shots.
More about this here.