Aim for the wealthier settlements (usually capitals) – you can see how much a city will return when sacked by hovering the mouse over them when you’re within striking distance.
As you acquire more gold through raiding, sacking, and external challenges like Hunts and Quests, your per-turn-losses become less relevant.