Keyboard with full hardware macro?

[Kiiryu]

What's a good keyboard that has;
-Full macro (for example, switch A key with CTRL+A)

-Switchable profiles (saved in the hardware, and switchable with a hardware button)

-Individually lit keys (For example, make WASD or others a different color, or brightness)
- Any price, but preferred under $200 
-  Not picky about key type

- Not too large (For reference, I have a G710+, and I like the size)

Bonus points if the software can make it detect the software being used, and switch the profile accordingly.

Keyboards which merely have macro buttons such as the G710+ are not enough. I don't really need a numpad so with or without is fine.

Any suggestions?