Best for specific macro work might be one of those LED ring lights. But it is kind of a 2-trick pony, if you count the amateurish use for portraits that is so fashionable now. But the cost is often low.
Otherwise, you can read whole books about different speedlights, advantages of each, and...