If I want to play a Yoko Taro game, I go a round in Drakengard not in Final Fantasy XIV. 'Because Yoko Taro' is as much a deterrent to some as it is a draw to others.

And it's a general thing with the collaborations. If they are for stuff you already love, your likely going to enjoy yourself and have some positive feelings for it. If you don't, they become a tedious annoyance and in the case of the Nier Collab, they become a tedious major repeated annoyance. They take three of our currently 25 alliance raids, which in itself is long and big content.
All other collabs are small, unobtrusive and usually time limited. The only other one that shows up in the roulettes is Monster Hunter. Otherwise, don't care about the boys on a road trip? Just don't do the Regalia event, or if you want the car, it's a one time and done thing.

And it's the same for the other collabs. I wonder whether they are really effective marketing tools. The players who enjoy the other IPs are going to play both games regardless, but are the players who have no previous connections to them or who don't like them too begin starting to go into them?

None of the collabs in the game ever made me check out the IP collabed with. I was either already into them and needed no further encouragement or didn't care about them to begin with.

If it had been a time limited event or a one of like Monster Hunt that gave you 2B glam, the whole thing would be a lot less divisive and fewer people would care about the Yoko Taro's story telling style.