Low traffic neighbourhoods are under attack. But really, car drivers have little to worry about – and communities much to gain