It'd be so useful to have keyword explorer data broken down by country and then major city e.g. London, Manchester, Liverpool etc.

The SERPs can vary wildly by location, meaning a UK wide result doesn't actually offer much insight.