I think it could be a good idea if you have a few standard configurations that could be applied to interfaces. Like the interface could be used as an en-host port, a voice port or a server port - and if you want to enable e.g staff to change the 'function' of one of these ports with an easy one-liner; but it could also be work to have the macro available on every switch where they are needed - on the other hand they can be deployed with a net-config job and verified with baseline templates; so there are several pro's and con'sdepending on the kind of network, the number of changes and who is doing a change - which should be all considered before introducing them.

BTW, I only know of one customer who used it in the past...