A new report reveals West Midlands residents value high streets more than the national average, but Birmingham ranks near the bottom of UK cities.