In the end Niara already said all there's to say about the topic. As it-s often the case.
The "Friends" cantrip should come with drawbacks, but they should ideally be a bit more nuanced than a "Everyone will go immediately berserk after using it".
A steep drop in "attitude", a line addressing that they aren't too fond of the player screwing with their mind and EVENTUALLY even going aggro if the starting predisposition wasnt too hot to begin with would do the job in most cases, outside of specifically scripted scenarios.