So, to put it simple, Macros in this game are all but useless in combat. There are plenty of fun macros you can make to help out with unimportant and non time sensitive abilities though... The biggest complaint I see on forums is that they offer no queue up like you get when using an ability without macros before your current cast is done. This is already a bit of a dps loss but manageable if not for the worse issue.
Here is what I want to see. Macros that do what they should. A huge example for me is on my Red Mage. I have a macro that looks like this:
/micon "Verfire"
/ac "Verfire"
/ac "Verthunder"
The Idea is that when I get a proc of Verfire, it will use Verfire since it is obvilously first in the macro. Then when there is no proc, but I have a Dualcast proc on, it will cast an instant Verthunder. This still takes a good amount of paying attention and can still be screwed up easily enough, but for a player who is used to it and does it well it is quite nice!
Unfortunately, due to some weird way that macros run in this game, often times Verthunder will start to hard cast even with a Verfire Proc on and Verfire being first in the Macro. Fixing this would be a huge way to make macros more useful! As it is now, I can use this macro and it will do the job I want, but occasionally at a huge dps loss due to having to cancel my hard cast and hit the button again to use Verfire sometimes.
If the game even had some sort of "/stopcast Verthunder" type macro command, I could put that at the start and it would fix my issue too for the most part. There are options to making it work and I really see no downside. There are many examples like this on other jobs too and quite frankly I just use it because there are sooo many buttons on most jobs that any way of combining them into less buttons with smart macros would be a huge help.
The last thing I want to see in this game is Macros like in WoW where you can bind one mouse macro to spam all your buttons for you and be the best Ret pally on the server...But at the same time, some freedom to combine buttons and manipulate the macro system for Quality of Life would be amazing! I know there is a new expansion coming out and the devs probably have big important things to work on, but it would be so nice if they could just have someone working on ways to make macros better, more useful, more rewarding, and more fun!
Oh and while you're at it... /micon is nice and all but we really need macros to show the abilities Tooltip, not just it's icon. And make macro use the Queuing functionality of abilities. Sure it probably has some complications, maybe even related to why the macro sometimes caste Verthunder when I have a Verfire proc, But I know you guys have some smart devs who can figure it out and program it to work. Again, I don't want a cloned system of other games, but I will say, if they can do certain things in other games, I know you guys can do it too, so "It's not possible in FFXIV" doesn't fly as a response :P
Hopefully someone important glances at this and finds some validity in it. I love the game so much but, as someone who loves programing and code, Macros are so fun and useful and not being able to use them in an effective way is saddening and frustrating! Thanks guys!