When doing endgame content with best gear, yes. I have it on my 510/520 gear.

Only time to not use Materia is when leveling DoW and DoM classes, because you will be replacing gear very fast.