I used to write scripts (macros) for Counter-Strike all the time. But since you could do it from the in-game console, it usually wasn't considered cheating (except the 2 glitches). Anyone could do it, if they understood basic knowledge of aliasing and console commands.
Things like:
- Bunny hop
- Semi-auto
- 3 round burst
- 180 degree spin
- Crouch Hop
- Flashlight Fire
- Rapid fire
- Crouch Jump (useful in old versions of CS for speed boost)
- Demo recording glitch (would resupply your ammo)
- Spectator rejoin glitch (allowed respawning after death)
The issue now, is in console gaming, it's not exactly widely available. You need to buy third party devices to macro/script. It cannot be done in the game. This is why people consider certain things macros as cheating.
On PC, only console COD players that convert over like to cry about macros. AHK is common knowledge in PC gaming and a LOT of good players (not just FPS) use it. I've seen it in RTS, FPS, MMO, etc.