At least in my life, the two most frequent issues about advice being worthless were it either required too much willpower, so any progress was lost as soon as focus shifted, or the "solution" offered by the advice was the same as telling someone "so don't have the problem." Actually, I'd classify the willpower issue as a subset of the "so don't have the problem" problem.
I’ve run into a third problem more commonly - miscalibration.
It’s very hard to figure out how much to apply most advice. Advice always lacks an understanding of the context it will be applied in. Far too over, it gets applied in too absolute of terms.