What's your question? Ask

There are several shrubs that come to mind. There are several dogwoods, silky, gray, downy and red twig, aka red osier dogwood. (Silky and gray dogwoods may be hard to find or available only at native plant nurseries.) Pussy willow (maintained as a shrub or small tree) and laurel (Kalmia) are options. Then there are chokecherry and chokeberry, winterberry, inkberry, American cranberry bush (Viburnum trilobum), and spicebush which all produce berries that birds relish. Some shrubs that make berries require more than one clone to cross-pollinate for the best berry production. Some will make berries in part sun just fine, others will have more berries in full sun. Some of the shrubs listed are best in acidic soil, others are not so fussy. Research your choices to find one that best suits your needs.

There are a few things that can be used here. This article will get you started: https://www.gardeningknowhow.com/special/xeriscape/growing-drought-tolerant-vines.htm

Can you specify the plant type?

It's not clear whether you'd like to plant flowers or shrubs for these areas. If you want bushes for filling in, you may want to plant a yellow azalea or a Jerusalem sage. Esperanza has a beautiful yellow flower that may work. Here's an article for you. https://www.gardeningknowhow.com/ornamental/shrubs/esperanza/esperanza-plant.htm

Most plants will tolerate acidic soil, but if you are afraid that it is too acidic, then you can apply Dolomitic lime to the soil This will help bring the pH up to around 7.

This article will suggest plants that attract bees: https://www.gardeningknowhow.com/garden-how-to/beneficial/attracting-bees.htm

There are many plants that will grow happily in the shade! This collection of articles will give you many examples to choose from: https://www.gardeningknowhow.com/special/shade