You need to be specific about your State to allow people to help you. The people nearest will have the most experience with what could be successful. East? West? Middle?

What @Sheila z8a Rogue Valley OR wrote. Location can mean everything. Also, any rose you consider will require support of either a trellis or wires anchored and strung on the wall as "climbing" roses will not attach themselves to surfaces as an ivy or creeping fig will. I would imagine, due to your zone, your best success with a climbing rose will likely be on the south wall of your home. The British have successfully grown less cold hardy climbers against hot walls where the passive solar collection has prevented them from freezing and encouraged them to grow and flower.

I'm in Virginia. The rose would be primarily on a south-facing wall, but have some tree cover depending on time of day, so types with some tolerance for partial sun would be better.

@mad_gallica (z5 Eastern NY) My partner and I both have woodworking as a hobby, so building a really sturdy trellis is definitely up our alley. In terms of height, I'm hoping for a rose that could get to be 15 feet, just so I could lead it up 8-10 feet and then partially across the house (which will make for some complicated trellis work, but that's a fun project for us). For pruning/training, I figure I'll be hopping on a ladder periodically, which is fine.

Baltimore Belle looks beautiful and has the height - thanks so much for the suggestion! What are the hips and fragrance like, if you don't mind my asking?

Fragrance is fairly light, but quite 'rosy'. A lot of sources claim it isn't fragrant, but several years ago I brought a selection of roses to a garden club meeting. Of course everyone had to smell them all, and that was the one that everyone commented on. Mine is in full bloom now, as are my allergies, and I can smell rose when I stick my nose in one, but don't smell it a few feet away. FWIW. Hips are on the small size, since it is a setigera hybrid. While I do a decent amount with rose petals, rose hips are something I've been scared away from. They don't seem to be easy to deal with.

Something I remembered this morning is that we used to have a member from Virginia who grew a lot of ramblers. She had a nursery for a while http://www.hartwoodroses.com/, 

and while the nursery is closed, the webpages and blog are still in existence. It's in Fredericksburg, so warmer than you are, but still pretty local.

BTW, a lot of people automatically think of multiflora hybrids when thinking of hardy ramblers. I don't know much about those because they find the natural pH of my soil too high for their liking. I've seen them do well outside of my lime pit.

Connie from Hartwood is alive and well, and active on Facebook. She regularly posts rose and home restoration photos.

I thought if I mentioned Connie someone who knew more than I did would comment :-)

I don't do Facebook.

The one book I have that has information on rose hips is Liz Druitt's The Organic Rose Garden. She tasted them! and it is a lovely book.

I've had Pauls Him. Musk for about twenty years. It's happily up a walnut tree (the Juglans hasn't gotten it), and I don't recall ever seeing hips. If it has them they are too far off the ground to be harvested, and based on the flower size too small anyway.

If you are near Staunton, see if you can contact Randy Trinis who had a nursery there and who had some excellent albas and I think I remember hips on some of them.

Outside of Charlottesville is Tufton Farm, another of Mr. Jefferson's farms and there is the Leonie Bell Noisette garden there, but they also have had a huge trellis structure with climbing roses on it. Some of them got Rose Rosette Virus and are now gone, but if they have big survivors, they might meet your needs.

If you can contact Dennis Wetzel who's near Charlottesville, he has had a passion for roses, especially the old ones. I don't think he's ever had a nursery, but he's gardened in zone 6/7 for decades and you'd enjoy talking to him/

@mad_gallica (z5 Eastern NY), thanks, that's really helpful! It sounds like an incredible variety of rose bush. I'll probably pick up Druitt's book before making any final decisions, but it's definitely the new front runner.

@stillanntn6b Interesting and good to know that Paul's Himelayan Musk isn't that hippy; one of the websites I'd been looking through listed them as an aesthetic feature so it's useful to hear that it's not a given. I assumed that even smaller hips could be used in a crabapple/berry way, but I've never had the chance to really experiment; I'll definitely be buying Druitt's book to see what she has to say. Tufton Farm's selection of native and heritage plants looks fascinating; I love an excuse to visit beautiful Charlottesville and will have to stare more at their fruit trees once they're accepting orders again; thanks so much for telling me about them!

I LOVE Liz Druitt’s book! Carol

I'll third Baltimore Belle. Super healthy, hardy, and graceful. Not fragrant to me, but it covers itself in flowers for about three weeks here. It just started blooming last week. Long canes, easy to manage.

I love the Liz Druitt book too. She has one with Mike Shoup too also great.

Francis E Lester is a fabulous once blooming rambler that gets large and produces an abundance of usable hips. Shropshire Lass by DA is technically a climber but also gives lovely, slightly larger hips.

This will not be helpful for your search, as I have no idea who it is (I even asked the lady who planted it, and she could not remember), but It was the first sight I saw as I recently went out into the garden of a Victorian B&B at which we were staying in Weaverville, CA. Lovely old old garden, and then I saw this rose. Definition of romantic, and I would guess it was a rambler, although the lady who planted it thought it might repeat in the Fall - she could not remember! According to her, this picture was taken on a day when it was "almost done" with its Spring flush,

Jackie