They do not "tear up the wood" or "tear up your foundation" :-) Climbing hydrangea and Virginia creeper/Boston ivy adhere by rootlets and/or adhesive root discs. These exude a kind of glue-like substance that helps the vine hold on to the structure but causes no permanent damage. If these roots/discs are removed - pretty easy to just pull off - they can leave some markings of their presence but not physical damage.

English ivy (Hedera helix) is a bit different. First it is evergreen, which the other vines are not, and can become extremely heavy. Its roots tend to creep and wriggle into any little crack or crevice it can find in order to support itself. It will also hold moisture against the side of any structure it is growing on, encouraging rot and contributing to the failure of mortar between bricks or stone.

Generally, if the brick or stone wall/facade or foundation is in good repair and the mortar sound, climbing hydrangeas or the Parthenocissus will do no damage at all. Can't say the same about English ivy nor would I ever recommend planting it.

I love that look, too, totally agree with you. What about when it's time to do maintenance on the wooden porch? Doesn't it need periodic painting or staining? The weight of a huge vine can sometimes overwhelm a support structure. You probably have a pruner, if things get out of hand.