Although if you're just duoing you might not need all the fancy features. I typically 3-box, and found it easier to write a simple script to have my healer heal/buff when I sent specific text phrases. Not very creative, but I wanted more control over the process so it's not completely automated.
Anyway, if you could give some specific tasks you're looking to automate, it might help to figure out what kind of macro would be best.
I have a pally and cleric that i would like to set up on an afk macro... boneyard would be cool. pally is very well geared and can solo easily. just lookin to get some xp while i sleep.