Don't be silly, there's of course a context to macro use.
Using it to say Hello/Sorry, or otherwise, no problem. Using all sorts of macros in various MMO games is generally accepted due to various tedious tasks implemented (click this 1000 times!), plus the nature of combat in these games is quite different.
If you're using a macro to counter recoil in an FPS, in effect automating the "pulling down" motion with your mouse that is of course flat out cheating. It is basically automating something that shouldn't be automated, you're supposed to do it your self, that's the gameplay.
In the same sense, for cRPG, anything that would automate abilities that you're not supposed to automate is cheating. Saying Hello, I'm sorry, and other minor tasks is of course OK.
Macro's in general is a huge grey area where you need to place a lot in the proper context.