You really sholdn't need much for macros unless a device is lacking discrete power or input commands, or you need to switch another device like an HDMI switch, to disable CEC/press the EDID button every time and that switch has fixed settings for these (which are different from what you need).
If you set the FIOS box to stay on and sometimes find that it's off, this is a good reason to place a power on command somewhere in the activity buttons but using a macro every time may leave it in its Power Off state when you want it ON. If the remote allows using logic (if/else, and/or) commands, great but that adds complexity to the programming. Harmony remotes usually have a Help button that allows it to store info about the activity commands and it really helps to ease the frustration when a cable box shuts down after an update. You can set the box to turn on at a specific time if it shuts off, too- this is one of the work-arounds we use when someone like Time Warner/Spectrum wants to make our lives hell by not allowing discrete power commands.
If you have thought about dinning lights or using other smart home devices, look at the Harmony Elite- it comes with a hub and it's very customizable.
