So basically... Materia vs. Sphere Grid?

Yeah, I think transient is generally better. I don't mind some permanence (like choosing who to use a Guard Source on) but customisation is helpful and encourages experimentation more. It allows for people to be creative with their builds when they are stuck instead of simply grinding up more power.