If they made materia do more than just increase raw stats, then they would need to add materia slots to all gear including raid stuff because everyone would want those advantages.

I think the reason they don't let you have that level of customisation is because it makes it much harder for them to balance it so certain combinations are not too powerful and deemed necessary to have.