Part of the problem is that fear based effects are necromantic effects, not enchantment effects. Which doesn't really make sense- if making a creature friendly to you is an enchantment, why shouldn't making it fearful of you also be an enchantment?
And the "buff' spells which improve mental qualities could arguably be enchantments, not transmutations. At least Relics & Rituals thinks so. And spells like Bestow Curse.
Oh, well. Here are some I made up- the first is like a charm crossed with enthrall, with a few elements of Hypnotism and Tasha's Hideous Laughter thrown in.
The others are "buff" spells that work by clearing the target's mind.
Co-opt
Enchantment (Charm) [Mind-Affecting]
Level: Sor/Wiz 2
Components: V, S
Casting Time: 1 action
Range: Medium (100 ft. +10 ft./level)
Area: All living creatures within a
15-ft.-radius burst
Duration: 1 hour/level
Saving Throw: Will negates
Spell Resistance: Yes
Affected creatures react to you in a more friendly manner. They are treated as having an attitude of helpful for the duration of the spell (see DMG 149 for information on NPC attitudes). A creature with 5 or more hit dice or a Wisdom of 16 or higher has an attitude of indifferent. Those of a different type (humanoid, abomination) than you gain a +4 bonus to the saving throw. If the creatures are currently being threatened or attacked by you or your allies, they receive another +4 to their saving throws.
If those not affected by the spell have unfriendly or hostile attitudes towards you, they may collectively make a Charisma check to try to end the spell. The check is based on the character with the highest Charisma and has a +2 bonus for each other character who can make a Charisma check of 10 or higher. The spell ends the spell if it beats your opposed Diplomacy check. Only one challenge is allowed per use of the spell.
Acts by you or your allies which threaten a co-opted creature automatically break the spell for that creature. All other co-opted creatures who witness this unfriendly act gain a new saving throw to resist the spell.
Rogue’s Wit
Enchantment (Charm)
Level: Sor/Wiz 2
Components: V, S
Casting Time: 1 action
Range: Touch
Area: Creature touched
Duration: 1 minute/level
Saving Throw: Will negates (harmless)
Spell Resistance: Yes (harmless)
This spell removes hesitations from a character’s mind, enabling her to react swiftly and surely in the face of danger. While Rogue’s Wit is in effect, the character retains her Dexterity bonus to AC (if any) regardless of being caught flat-footed or struck by an invisible attacker. She may take attacks of opportunity even while flat-footed. Attackers on opposite sides of her do not receive flanking bonuses (and thus cannot sneak attack). However, a rogue of at least 10th level flanks and sneak attacks the character normally.
Ignore Distraction
Enchantment (Charm)
Level: Sor/Wiz 2
Components: V, S
Casting Time: 1 action
Range: Touch
Area: Creature touched
Duration: 1 minute/level
Saving Throw: Will negates
Spell Resistance: Yes
This spell enables a character to use her skills reliably even under adverse conditions. A character under the effect of an Ignore Distraction may take 10 with any skill check, even if stress and distractions would normally prevent her from doing so.