'Left behind' neighbourhoods have poor public transport but are more reliant on it, new research shows