Maybe this post should be in bug section, perhaps it has been asked already, or perhaps it's all hard-coded and nothing can be done.
As per d20srd
Restoration, Greater
https://www.d20srd.org/srd/spells/resto ... reater.htm
Conjuration (Healing)
Level: Clr 7
Components: V, S, XP
Casting Time: 10 minutes
This spell functions like lesser restoration, except that it dispels all negative levels afflicting the healed creature. This effect also reverses level drains by a force or creature, restoring the creature to the highest level it had previously attained. The drained levels are restored only if the time since the creature lost the level is no more than one week per caster level.
Greater restoration also dispels all magical effects penalizing the creature’s abilities, cures all temporary ability damage, and restores all points permanently drained from all ability scores. It also eliminates fatigue and exhaustion, and removes all forms of insanity, confusion, and similar mental effects. Greater restoration does not restore levels or Constitution points lost due to death.
Heal
https://www.d20srd.org/srd/spells/heal.htm
Conjuration (Healing)
Level: Clr 6, Drd 7, Healing 6
Components: V, S
Casting Time: 1 standard action
Range: Touch
Target: Creature touched
Duration: Instantaneous
Saving Throw: Will negates (harmless)
Spell Resistance: Yes (harmless)
Heal enables you to channel positive energy into a creature to wipe away injury and afflictions. It immediately ends any and all of the following adverse conditions affecting the Target: ability damage, blinded, confused, dazed, dazzled, deafened, diseased, exhausted, fatigued, feebleminded, insanity, nauseated, sickened, stunned, and poisoned. It also cures 10 hit points of damage per level of the caster, to a maximum of 150 points at 15th level.
Heal does not remove negative levels, restore permanently drained levels, or restore permanently drained ability score points.
If used against an undead creature, heal instead acts like harm.
Heal, Mass
https://www.d20srd.org/srd/spells/healMass.htm
Conjuration (Healing)
Level: Clr 9, Healing 9
Range: Close (25 ft. + 5 ft./2 levels)
Targets: One or more creatures, no two of which can be more than 30 ft. apart
This spell functions like heal, except as noted above. The maximum number of hit points restored to each creature is 250.
I did some testing. While Heal should end confusion, I know NWN2 doesn't because it's coded so.
Anyway, I cast Confusion. Heal and Mass Heal did not end it. Greater Restoration did.
I cast Chaos. Heal, Mass Heal nor Greater Restoration worked on it. I was not able to end it. This is likely because the EffectInsanity is used instead of EffectConfusion. But it should.
Could they be fixed? Or at least Greater Restoration? I know a DM can and has allowed Heal to be used in this manner, but it doesn't really help with mechanic play.
It does feel a little odd that as a cleric I can mess someone's head but I can't reverse it, though technically I should.
Thought it was worth it throwing it out there since there's been changes with spells like Protection Against Alignment lately.