This is a pretty confusing topic - you'll hear people harp on about making 140hp whilst using the original Garrett T2 making 32psi boost.Yet for example my GT2052V made 175hp at 20psi of boost....
Yet you'll be shocked to hear when I also say - more pressure at the inlet will make more power...
HOWEVER - that's in an ideal world - unfortunately turbochargers are not efficient - efficiency is the key to unlocking the turbos potential - don't utilise the turbo hard enough, efficiency drops, run the turbo too hard, efficiency drops and you'll overspeed and destroy the thing - there's a "sweet spot" for every compressor. This is where your compressor map comes in - this is what shows you how much air you can move, at what shaft speed, at what pressure ratio and what efficiency the compressor would be working at.
Here's a compressor map for a GT4508 - stonking great turbo. First thing you'll probably think "where's the boost axis" - well you'll probably see something called "pressure ratio" - essentially this is boost, however as you can see, it starts at a value of 1 - in this case we'll take 1 to be barometric pressure (around 14.7psi, you've probably noticed if you work in new money that's bang on 1bar) - this takes into account what happens when you go up the side of a mountain or "compound" charge the engine - whole other kettle of fish.
Along the bottom - you have airflow - at this point everyone is probably shouting "see, flow isn't the same as pressure" - well, unfortunately it is, since your engine isn't changing in size, the airflow is a constant at a given engine speed. Next thing to take into account is the curved lines with numbers at the end of them. These are the various different shaft speeds that the compressor would be spinning at for that given pressure and airflow. Finally there's the big circles or "islands" - these are the "efficiency islands" that the compressor would run at - the closer to the central island, the more efficiently the turbo is running.
These "efficiency islands" are key to understanding what's going on here - notice on this turbo, your peak efficiency is about 78%!! Not great at all, and if you look at the compressor map for a GT1549:
Anything past 1.6 bar of boost and you're off the scale!!! The turbo shaft speed is off the chart, too fast for the poor thing! Efficiency through the floor etc - you can see here now that it's very easy to run a turbo RIGHT out of it's efficiency and totally overspeed it.
TL;DR: Essentially my point is that no, it's quite complex to understand what turbo will be best for an application, high pressure is good, but not at the expense of poor efficiency and overspeeding. It's all to do with efficiency. If you're running the turbo outside of it's efficiency range, you're generating a lot of heat rather than moving air - heat is bad, it reduces your air density and therefore the amount of oxygen atoms you have to burn your fuel with.
I keep saying I'll do a big post on understanding compressor maps fully one day - maybe this will push me to do it.