Of all the books I checked out, these three were the most helpful:
Tim Wood, Alison Beck
This one keeps it simple and keeps it local for sure success. If you're one who easily overwhelmed by too many options this would be a good choice. As for myself, I had to know about all those other vines too!
Armitage's Vines and Climbers: A Gardener's Guide to the Best Vertical Plants
Allan M. Armitage
This one was very amusing! I loved the author's humorous descriptions. One vine was wryly described in this way "once you plant this vine, you will probably always have this vine." Good to know! Lots of great photos too.
Ortho's All About Vines and Climbers
Equally as extensive and photo-filled as the above book, very useful as a guide.
My first leanings were toward Clematis and I even had a personal recommendation for the Snowdrift variety which blooms in the fall. However, after consulting with my dear husband, I think we have settled on Honeysuckle. There are a bunch of different varieties, lots of reds and yellows and some whites I think. I want to do a red and a yellow and I want to make sure they bloom at different times so I have flowers more of the season. They are supposed to attract hummingbirds, which is a lovely bonus!
Any vine stories to share out there? What grew for you?