I never had any repercussion using Guidance. And I'm using it constantly. So I'm a bit perplexe here.
But yes, people reacting badly to Friend is more than understandable and fits the rules for this cantrip (like mentioned by RagnarokCzD).
Rule in Baldur's Gate 3
Enchant a non-hostile creature to gain advantage on Charisma checks against it. Once the spell ends, the creature knows it was Charmed and might accuse the spellcaster.
Rule in the DND 5th Edition (main reference for this game)
For the duration, you have advantage on all Charisma checks directed at one creature of your choice that isn’t hostile toward you. When the spell ends, the creature realizes that you used magic to influence its mood and becomes hostile toward you. A creature prone to violence might attack you. Another creature might seek retribution in other ways (at the DM’s discretion), depending on the nature of your interaction with it.
I admit "might accuse the spellcaster" is a bit vague. But no one likes being manipulated, having their agency removed, being mind-controlled. Those things can easily be seen as evil.