So how do you guys feel about add-ons for FFXIV possibly.

[Brigandier]

I'm just a little cautious of what can of worms will be opened once they give full access to the games inside.

They won't have full access to the "games insides", they'll have access to SE's API. The amount of content they have access to will be completely configurable by SE, and will most likely be limited to collecting information (i.e., position, HP/MP, party member stats, etc) and displaying them on the screen. I highly doubt the API will include anything that would allow for automation (unless they use the API to get the info, and use ToS breaking means to automate based on that info).

EDIT: Sadly, not all players are familiar with programming and immediately think "Oh no, bots will be everywhere and I won't have a chance." If SE adds an add-on system you can bet they will be heavily restricted.