We have a ton of woodpeckers around the house, though not the nice one that started this conversation, we get Flickers, Piliated, Downy, Hairy, and very occasionally at Red Breasted Sap Sucker. The Flickers always pound at our metal pipes coming out of the roof but don't do anything else to our house. The sap suckers put holes in a number of our trees which they go back to pick insects out of the sap, otherwise they don't cause issues.