It will work in any game. The macro controller is designed to record and replay different moves and button combos, you could record a move for example in WWE'12 and speed up the button combination for it if necessary in the software, and then be able to re-enact that move with the press of just one of the 6 extra installed tactile switches on the controller (you have to assign it to whichever switch you'd like)
For what it does, it is very worth the price, if I could afford one I would buy it. It requires that you be able to use and understand the macro software though so keep that in mind. It will work on all the call of duty games.
I've been playing with mine for a while now and I'm not banned. I used to hack my gamerscore and other things for different games and I haven't been banned (just had my gamerscore reset like last year or something though)