My thoughts on flash for macro:
1) Ringflashes - snap them on the end of the lens and away you go. They are simple and easy to use. The problem is that the light that they give is very flat and even over the whole subject and that means you won't have much shadowing; so a lower contrast and a lack of dynamic lighting that is often more pleasing to the eye in artistic or creative photos. For this reason ringflashes are often popular with dentists and other areas where they specifically want that flatter, even covering of light.
Now many of the good quality ring flashes let you change the power output of the two tubes inside (one down the left and the other down the right) so that you can introduce some shadowing; but the angle is always limited (left to right or right to left if shooting in landscape mode).
The other problem is that you've very little to almost no ability to add a modifier to increase the size of the apparent light source from a ring flash; this is because its mounted right to the front of the lens so any modification is cutting right into your working distance - ok for a longer macro lens and for a static subject; but for insects or shorter focal length macro lenses its almost impossible in a practical sense. This means you've a reduced ability to soften the light from the flash to a more pleasing result.
2) A good bracket for flash combined with a regular speedlite flash and a diffuser can provide not only a very good quality of light, but also leave you much more room for creative control in where you position the flash and how you diffuse the light from it. Now of course you can do the same with a ringflash by mounting it to a bracket and then shifting it around likewise - however ringflashes have a reduced power output (more than enough for most typical macro photography) so outside of macro their applications are more limited* - whereas a speedlite flash retains a use over pretty much all areas of photography, making it a very solid investment.
A good flash bracket is important and there are many on the market; sadly many are aimed more at portrait work than macro. My personal preference is to reach outside of photography gear and instead to RAM-Mount. This company produces a range of brackets and extenders focused on mounting devices to bicycles and as such they are more than strong enough to steadily hold a flash (Even heavy ones like the 580EX2) without any wobbling whilst shooting (some of the cheaper brackets do wobble which is fine for portrait or common uses, but a nightmare for macro).
*Ring flashes are often used for portraits, however the type of ringflash used for portrait work is not a macro ringflash; instead its typically a modifier for a speedlite and works by having a much enlarged ring (or dish) which results in the softer light. The macro ring flash is simply much smaller and thus not as suitable for the soft nature of the light many want.