Some good advice here, despite the disagreements, but there the thread missed the starting point. You wrote:
the advice you've received seems focused on bugs, but the lighting choices for flowers are very different. So I will add my two cents/pence:
First, in almost all macro photography that I do--lots of bugs and flowers, but not much else--a key regardless of the choice of lighting is that it should be diffused. One of the reasons why natural light is often (in my opinion) inferior is that when it is bright, it is often harsh, and this really matters in macro work. And in the case some bugs, managing reflections is very difficult, and the better the diffusion, the better the result. For that reason, regardless of what options you pursue, I would advise you to spend to trying out different types of diffusers. For example, in doing bugs, I use multiple layers of diffusing material, and I usually include some sort of paper, as the fibers help. I currently use two sheets of baking parchment paper as my final layers, but I (and many others) have used layers of paper toweling to good effect. Find something shiny and take a bunch of pictures with different diffusing options to see what works best.
For bugs: for the reason Richard described, I never use a ring light. I use a single flash with a homemade diffuser held close to the end of the lens. One of my is a do-it-yourself rig that I constructed out a $7 straight bracket and two miniballs:
I also sometimes use a Wimberly bracket, which is much more secure, but it is heavy and expensive:
The diffuser itself is constructed from an old soda can, lots of gaffer's tape, and in its current incarnation, the two sheets of baking parchment I mentioned. (Google "coke can diffuser macro" without the quotation marks.) One disadvantage is that if you add or remove an extension tube, you have to redo the whole rig to get the right length. Another is that sometimes I want the lighting on the other side. This rig is heavy and poorly balanced, so I prop it up with a monopod that has a tilt head. This is much faster to use than a tripod. I use this both in sunlight and in shade. I'll post a few images here to show the quality of lighting. In open sunlight:
In deep shade:
For flowers in the studio: one choice is strobes or continuous lighting. I prefer the latter because I can see approximately what effects it has as a move the lighting around. However, it requires long exposures. Usually, I use two halogens in hair lights, often one bounced into an umbrella and the other direct, but with diffusing material in the front. For example:
Here are a few examples of shots taken that way, starting with one that I think was the subject above:
Finally, for flowers outdoors: consider carrying a small collapsible diffuser.