The pressure is controlled by the bypass valve spring regardless of pump volume. Pump output is linear with RPM so as the pump spins faster, it pumps more oil. As the pump tries to stuff more oil through the engine, the pressure will rise as the engine can only consume so much oil. Once the pressure rises to the point the bypass opens, any additional oil is just returned to the pan. A bigger pump will just cause the bypass valve to open at a lower RPM and then just pump more oil back to the pan. If the bearing clearances are within factory specs, a standard volume pump will open the bypass well before 3000 RPM. The larger pump offers no real advantage. If you use a stronger spring in the bypass valve, the oil pressure will be higher before it begins to dump back into the pan. Higher pressure does not mean more oil is going anywhere, sometimes the opposite. Higher pressure WILL increase the load on the intermediate shaft, cam and timing chain as well as requiring more power to operate.
The short answer is the stock oil pump is just fine for most applications with normal bearing clearances.
The old warning about a high volume pump sucking the pan dry at high RPM is not typically the case. Too much oil to the valvetrain is what causes that.