Answer: Climbing roses are a good choice in terms of attractiveness, but they are sometimes disease-prone which means you'll have to do some regular spraying and pruning. Other choices might be Coral Vine (very vigorous), Trumpet Creeper (very vigorous), climbing Hydrangea, Gold Flame Honeysuckle, Passion Flower, Carolina Jessamine or Japanese Star Jasmine. I've listed these in order of height (30' for the most vigorous growers, 15' for the rest). All flower, all are fragrant and all grow best in full sunshine.
Best wishes with your new vines!
Q&A Library Searching Tips