if possible, do visit the first page of this thread

while i'm sure razer, corsair and logitech has keyboards that has macro functions, i'm still putting the ability to change keycaps with standard layout keys as one of the priority in my recommendations.
there's keymapping software out there, such as AutoHotKey.
use this with any keyboard, you get yourself a keyboard with the ability to keymap or macro it.

you can't go wrong with filco if what you are looking for is quality.
HOWEVER, one downside about filco is the stabs they use, which is COSTAR stabs, which i'll explain briefly later.
otherwise the other best option would be ducky.
i have ducky shine 2 and filco majestouch 2 tkl, hopefully that makes my explanation slightly more reliable HAHA!

Pros of COSTAR stabs - Keypress feeling is very natural for the big modifier keys.
Cons of COSTAR stabs - Changing keycaps will take more time compared to CHERRY stabs, and sometimes have the risk of breaking the inserts (or losing it). So if you like to change keycaps often, you will get pissed off with COSTAR stabs.

Pros of CHERRY stabs - Changing keycaps is a breeze, won't risk losing any part of the stabs or breaking it.
Cons of CHERRY stabs - Keypress feeling can be mushy and annoying for the big modifier keys. HOWEVER, this can be fixed by doing leg clipping mod on the stabs (but this requires you to open up the keyboard and desolder some keys, if not all, to remove the stabilizers and mod it.)