I find that tolerance to tartness is highly personal. My younger daughter and I will happily nibble on aronia (an extremely tart berry) - my husband and elder daughter find that totally unpalatable.
I find elderberry (canadensis variety) to be somewhere in the middle of the tartness scale for berries (where blueberries/raspberries would be at the very top of the "easy to eat" scale).
I generally don't bother with complex processing: I'll simply mix the tart fruits in small amounts with sweeter fruits, like apples in
apple crisp, in a smoothie, or in fruit compotes. I find that this is where the complex flavors of the wild berries can really shine, when they're not overpowered by the tartness and not completely smothered in sugar either (as they would in, say, jam). They also do great in savory meals, the way barberries are used in Persian cooking (often in rices).