SWG was a great example of Macros implemented where it was abused. You could write a macro and put your guy in the middle of a spawn point and set him to kill anything as they spawned then go out to dinner, movie or whatever and come back to find he has enough experience to master the profession and also collected a ton of credits and loot.
Macros are not needed in games period. If you're not skilled enough to play a game without macros then maybe you shouldn't play it.