I don't like full character customization, because it makes every character the same, which makes battles a very simple, everyone-cast-ultima-four-times-a-turn affair. However, I don't like a really strict system like IX's.

I'd say the best system was FFVI, which gave everyone the ability to learn each spell, but also gave them unique moves to distinguish them from each other.