It is all in the tuning. Well that and delivery rate.
Peak pressure always hovers around TDC,but that is where it does the least good for power production. However, there is a lead time on the fuel burn. So you have to deal with the pressure there to get good value as the piston moves down. It is a tradeoff.
Now, you also have to add that you need at least a minimum pressure to light off the fuel and a couple dozen other small factors.
To answer the question; it depends.
I've observed pressures that have maxed out my 5000 PSI sensor that did not make good power and 3500 PSI peak that made more than most. Stock/Stock engines tend to stay below 3000 PSI on purpose since this reduces emissions.
Moving the injection 1 degree can reduce the chamber pressure 500 PSI