is it better to steam milk at high or low pressure

Neither is better. The ideal steam wand pressure is relatively low, around 15-20 bar (2.1-2.9 atmospheres). This allows for a smooth, silky microfoam and prevents over-aeration, which can lead to an unpleasantly thick or separated texture. High pressure steaming can introduce too much air into the milk, resulting in an over-extracted shot.