Figuring out what one wants from a plant is a vital step in building a healthy and mutually beneficial relationship with it. Sometimes those eye-candy photos distract us from more important things...
Tea Noisettes are the first group of roses to come to mind. I've never had a chance to grow any of them because they do require the warmth of a zone 8 garden, but there are some members of the tea-noisette group that are supposed to be very good at climbing, producing fragrance, and repeat-flowering: Lamarque, Celine Forestier, Gloire de Dijon, Marechal Neil, Reve d'Or, and so on. (Antique Rose Emporium or A Reverence for Roses)
Some other random possibilities, not all strictly climbers: Appljack, Climbing Mme Caroline Testout, Clair Matin, Apricot Impressionist. (Heirloom Roses) Marchioness of Londonderry. Marchesa Boccella, Ispahan, Sombreuil, Lady Banks (the white one that smells of violets), Don Juan, Penelope, Teasing Georgia, A Shropshire Lad, and Graham Thomas. (David Austin Roses, ARE)
Some of my roses are underplanted with herbs such as peppermint, spearmint, tarragon, culinary sage, salvias, catmint, and wormwood so that I can crush them as I go through the garden. I also grow an eglantine rose Amy Robsart whose leaves, when crushed, smell of green apples. In six years it has gotten to twelve feet high. The flowers are never more than two inches across and it does not repeat. But I do love the smell of the foliage. (Not sure it is in cultivation at this moment.)
Some roses can be hard to grow in the best sites. Other roses, if given a good start will endure very difficult locations. I think most of the roses I've listed above fall into the second category.
I hope you find a few roses that will suit your needs perfectly!