With so many possibilities in the Sorbus genus, it is difficult to decide which Mountain Ash to use. If a narrow upright form is needed, consider the Cardinal Royal Mountain Ash.
A minor downside is the heavy fruit that can pull the limbs down, disrupting the perfect upright form. In the nursery we have seen this as a short-term issue, remedied by a flock of birds that can quickly devour the fruit, with the limbs then returning upright. In our experience, we have found them to transplant easily. We have also observed a relatively small, non-aggressive, and limited root system, thus I would not anticipate them to cause any infrastructure damage.