I discovered more or less by accident that I could use a beauty dish for indoor macro photography. I had just finished with a model shoot and the beauty dish was still up. The window light wasn't bright enough for my taste, so I moved the vase with the flowers directly under the boom with the light attached to it, and I started taking pictures. The picture you see above was shot at f16, in order to get some sharpness to the petals, although I was very close to the subject.
Sure, you can have beautiful light from pretty much every modifier, and as always, the larger, the better... have fun hanging a big softbox or an umbrella upside down on your lightstand. It's just not practical to shoot a small object with a large modifier. Small modifiers usually create harsher shadows, but figured, if I move it far enough away from the subject, it may work.
The Roundflash Dish works well for this and many other purposes. It casts a bright, even light, and catchlights in the eyes are nice and round (with a small black dot in the middle that's easily removed in Photoshop.) In this particular scenario, the beauty dish almost looked like sunshine, and I was very pleased with the outcome.
Back to the picture: The light comes from straight above from a Godox V850 flash inside the beauty dish. It's hard to give you the settings for that, but I'm pretty sure it was on full power because of the small aperture. The camera is at about a 45 degree angle, on a tripod. I placed the flowers on a stool, and I sat on a chair, with the tripod between my legs, and the ballhead not tightened all the way. I basically moved the camera around on the tripod, while at times also tipping the tripod towards the flowers to get the angle I wanted. I obviously tried to steady the tripod as best as I could, but I didn't have problems with blurry shots. The only problem I encountered was when I got overzealous with the positioning and the camera got between the light and the subject. At that point, I just moved the flowers around a bit and found the light again.
Professional? Nah, not really. I always had a very nonchalant approach to macro photography. Only recently did I even introduce a tripod. The fact that I'm still not using it properly doesn't bother me one bit. Sure, get the exposure right. And the focus. But when you dive into macro photography, it's like you are in a different world. I compare it with a diver that goes under water. Above water, you spend all the time to set up a particular shot, only once you dive down (look in the viewfinder) do you realize that if you shift the camera ever so slightly over to the left, and up, that's where the composition is just perfect. And instead of getting back up to reset the position of the camera, and potentially lose the spot you just found (because above water everything looks so differently), you say under, and you just make it work... even if it means you tip the tripod and steady everything with your hands.