Most super-Earths formed by dry pebble accretion are less massive than 5 Earth masses