Quick answer
Cavity wall insulation can be a sensible mid-cost upgrade, but the payback case is usually less automatic than loft insulation. It tends to look better where the wall type is suitable, the home is heated for long periods, and the current wall heat loss is meaningful. It looks weaker where suitability is uncertain, the heating spend is modest, or damp exposure is a concern.