You are assuming a greenfield scenario, in large brownfield projects it is quite easy to degrade performance by innocent changes. That is usually when the perf goes to trash.

It takes a lot more work to keep performance good in a large project than just letting it degrade.