I haven't grown climbing hydrangea, so I can't comment on it. I do think you'd have some success with honeysuckle, which grows fast and just about anywhere. You also might look at trumpet flower vines like Campsis radicans -- it's also very vigorous and thick, although it can become invasive so you may consider whether it would become a weed in the nearby forest. I believe there's a Chinese Wisteria that's hardy down to zone 3 if you want that. Wisteria is a very substantial vine, though, and when its main stems get like tree trunks, they might tear up your fence.

I think all of those will provide effective visual screening. There are other things that would look nice, like rambling or climbing roses or clematis, but they may not be thick enough to block vision through the fence. Perhaps some of the roses would. Come to think of it, there are some very large, rambling clematis that might work, too. I think one is Clematis montana. But you'll need to check whether it's actually hardy in your area.

Apparently the hydrangea can get quite large as well...trunk up to 8" and 80' length/height...tho I can't seem to find any in this area. I'm looking at several of the clematis as well. How about a simple berry? The trumpet flower is a good idea.

You're probably talking about raspberries, right? It depends on the fence. They're not a good choice for weaving into a fence where it would be hard to pull the dead canes out. But if it's just strands of wire, like barbed wire, it would work. The thing with raspberries is that they fruit on last year's canes, and then you have to cut those canes all the way to the ground and let the new canes grow so they'll produce next year's fruit. The constant removal of canes may be a problem with your fence.

You could also grow annual vines like Morning Glory. It will reseed each year and grow quickly. But after a while all the old dead growth from previous years might get messy.