Darknacht nailed it. I dont' mind simple macros nor do I really care to police them if the player is there, sitting at his computer, still forced to initiate the macro and diligently perform the 'next step'. Complicated macros which automate entire processes while you are able to take an extended leave from your computer are where I personally draw the line.
That being said, Diablo could 'automate' their game so you click a monster once and your character keeps swinging on the mob over and over until it dies. Some people enjoy the zen of constant clicking. Others don't. Salem automates plenty of processes. It felt acceptable that the tedious task of prospecting be one that was click-happy.
Or not, if you find 'click and watch' more fun with your silly little macros.