OutlawZ, I don't think that's cheating, I myself stand on top of a cliff side when fighting those things to avoid damage. It's not taking advantage of a glitch because there is no glitch. That's the way the programmers designed those guys. Had they given them a ranged attack, there would be no way of doing this, but they didn't.
Vandelay, rarely does a device like the Action Replay cheating device you show there (Or similar products) take advantage of any cheats left hidden by developers. Those things look for certain lines of code, and then "freeze" them how they are or change the code and then freeze it. They give you unlimited health or ammo, unlock levels, and provide other functions by searching for the code related to what you want and changing it to match the value you want, sometimes based on work done by hackers, other times by comparing a new value to a previous value. (You have 100 health, then get hurt, bringing you down to 88. The cheat device compares the lines of code, or you do it yourself, to find the code that controls your health or ammo or whatever.) ~I don't have any of these cheat devices, so some of this may be a little off.~
There are games like Rouge Squadron that have cheat menus however. These use real cheats that are programmed into the game. There are other games that have hidden developer consoles (Or not hidden) that allow you to "cheat" using the commands that the developers used in creating and testing the various aspects of the game.
I like games like that, and after playing through the game the first time (Without cheats.), I like to go through again, and have fun with the cheats. Games with a noclip mode, and/or the ability to change your jump height are especially fun to play with! Invincibility gives me a chance to stop and go through at my own pace, I can check out the little details around me, see things that I missed before, while the baddies are wasting their time trying to hurt me.
And finally, on topic, I don't think macros should be used in online games at all. Even those who are using them as something to prevent themselves from getting tired having to press a button over and over again are getting an advantage over anyone who doesn't use it. If I'm just pressing the button normally, I'm going to wear out faster than someone who isn't putting as much effort in to pressing by using a macro. So even these little "hand savers" puts me at a disadvantage. (Hypothetically, at any rate. I'm pretty hard core when it comes to gaming, I can play tirelessly for expanded periods of time. Years of training. :P) Using a macro in a single player game is fine, different strokes for different folks, it doesn't hurt anyone but the person who is making the game easier for themselves.
Call me selfish, tell me I have an over-inflated ego, but because I've worked quite hard to get as good at games as I am now (And I still have plenty of room for improvement), I don't want some punk player who has no skills what-so-ever, but likes showing off using macros and cheats, showing me up because they cheated to get there. Using a macro is a lot like kill stealing. Getting whatever the benefits without any of the work. (But without the blood sweat and tears of the other players.)
I finish games fast enough as it is, so I don't need nor want cheats to help me through a game.
Sorry if parts of, or most of this post makes no sense... Especially that part about how the Action Replay works. I think I could have explained it better, but... It's late, I should be in bed, and I think I might of rambled a bit.