Study finds reality does not reflect vision, with poor or no public transport or active travel infrastructure, and lack of local amenities