Rowan trees are quite pretty and have a fairly light canopy so don't cast too much shade - are also good for wildlife.
They have pretty (mostly white I think) blossom, autumn berries and some have good autumn colour
Couple are
Sorbus 'Joseph Rock' - red stems, red autumn colour, yellow berries
Sorbus aucuparia - good autumn colour and red berries
This cherry has good early autumn colour and the bark is attractive as well - Prunus sargentii but agree with nutcutlet lots of the cherries are very boring and the blosson will only last a week ot two.