I am not against macro either, just indifferent and have it at lowest priority. Just want to know the usage of the people who do find it important to have that function.
games that require "MIA" messages (DOTA2, HON, LOL), i've put an auto message script saying MIA on team chat, it helps me send split second MIAs when people suddenly teleports to other lanes or something of similar scenario.
games that profits on looped clicks (auto-spam click) at specific speeds if needed, keyboard smash came into mind(managed to get mine at 600+clicks per second, pretty much crashed firefox)...
games that profits on precise pre-programmed sequenced keystrokes, band master or the old O2Jam could be potential games although no idea if they could call this cheating.
ultra-high speed clicks (exceeding native double/triple-click speeds) with a set amount of clicks, specially effective with pistols as a pseudo sub-machine gun.
"thereisnourflevel" go figure.
----- outside of games -----
anything that works with "alt+f4", pre-programmed panic button!
pre-programmed sequenced clicks (shift+"?", ctrl+alt+delete, alt+tab), works well on some applications.
retasking buttons or keys, having some of the far buttons nearer your left-hand is quite handy.
and others, i haven't tried using mine's advanced commands yet, theres potential to use the "if" and "equations".