Is over-optimization bad for a website?

On Page Optimisation

Is over-optimization bad for a website?