How can I have forgotten saxifrages
Lovely things.
Looking at the thymes in my garden, they come in all sorts of shapes and sizes. Some such as Doone Valley are fairly big and spread to quite a large size. At the opposite end of the spectrum there's a tiny alpine thyme called something like thymus minutia which spreads very slowly but makes a dense, close mat. There's everything in between, from cream and white flowers, variegated, scented, upright, sprawling. They are great at this time of year, and the bees love them, but they will be over soon.
Flowers for later in the year, well I can only think of dwarf pinks, which come in a variety of colours and all smell gorgeous. They don't really trail exactly, but form cushions.
For the autumn there are gentians, which come in shades of blue and are magnificent for a few weeks. They don't trail very far but would look good in a wall - not one made of limestone though as they are acid lovers.
There are also some ground carpeting roses. modern varieties, but they take up quite a bit of room. Depends on the size of your wall, and the scale of the plants you want.