I feel that local models are better for "processes" where you need a degree of predictability. Like summarising the daily weather for the family chat bot or analysing email inbox priority.

SOTA cloud models are more for open-ended tasks where you need "creativity".