Macros?

So I am curious as to how many of you use a macro program of some sort and whether or not your payed for it or downloaded a free or open source project? Any recommendations on what to look for, what to avoid or maybe even to just forget it?