Over-Optimization kills while under-Optimization hurts

While it is safe to say that every web page requires to be optimized so that it can be set up for success; how much optimization is enough, is there a defined limit beyond which