Action bar is best for Gamepad, IMO. It's easy access and just works better with a gamepad. All I use macros for are for items (which I will use the action bar for once they let us put items on it), gear swaps, and specific stuff like a "Gather together" message.

KB players will get more mileage from macros, especially if they turn off subtargeting for their ease of use.