I'd put my vote on Scarlet Crush. I've tried em both, they both will work, but Motioninjoy has always felt very sketchy to me, and to actually get it fully uninstalled so that it would stop recognizing controllers and let Scarlet Crush take over I ended up having to remove registry entries. Not very trustworthy software there.

And yes Scarlet Crush does essentially make the computer recognize it as an XBox device, however at least specifically to FFXIV I believe there's an option that you can tell it whether you want it to display the buttons as XYAB or X^O[]. That's something that would be determined by how individual games choose to handle/program it. A lot of games I'd guess would probably just label them as Button1, Button2, Button3, etc. but I haven't really done any testing of this myself or even used the controller recently for any games.