I tried to find a mechanical macro keyboard to replace my Logitech G15 non mech, I tried a couple, but didn't get on well with the software included with them or limitations of the macro setup. I swapped to a standard TKL mech and a logitech G13, lots of them about as new or barely used on eBay, many people buy them and don't like them. There are others (Razer nostoromo, orbweaver, others) but I liked the G13 because I use the quickmacro feature often.
Another option is maybe a macro mouse, I have a Razer Naga that has much of the same functionality as a macro keyboard.