Don't get into Macro unless you want your wallet seriously lightened! (j/k)
A great accessory to go along with that flash cord is the Wimberly macro bracket. It allows you to position your flash at just about any angle. http://www.tripodhead.com/products/flash-bracket-macro-brackets.cfm
I started taking macro shots of bugs a while back until my wife saw them on the computer and threatened to tell all of our friends! Just another facet of photography which has it's own set of rules to learn.