Unable to answer "What’s the name of this street?" – Residential Road – https://osm.org/way/17453250 via StreetComplete 58.2:

W Main street doesn't go north like this before continuing. It keeps going straight east-west.