I think in case of Blind, Charm, Curse, Fear, Summon Ghost/Undead, it's safe to say these are quite useful in the first part of the game (everything pre-Sentinel Island) but lose their usefulness after that.