It's more or less a placebo effect ontop of freeing up space used by background programs that most people arn't proficient enough to do anyway.
Obviously modern machines it doesnt help much, which is why ppl say it doesnt do anything.
On low end machines game booster and the like programms do help.