Hello and thanks for the feedback.
I work for the City of Vancouver and was tasked with updating OSM to match our street network, in particular correcting errors regarding unclassified streets. I don’t really agree that it’s valid for these streets to be unclassified; for the most part these are normal streets that have a transportation function and should be classified as such. 3rd party data sources like Streetlight Data are omitting important data based on the these streets being unclassified. It’s also important for people who use OSM as a base for network analysis that the streets be properly classified in order to set up preferences and hierarchies.
I do understand your concern with the roads in Stanley Park and near the Port. The “Residential” classification is not ideal as it refers to land use, not transportation function. I do think there is an implied transportation function that these are local roads, meant to serve destinations along them, and not for through traffic. We have many non-residential areas of Vancouver where the “Residential” classification is used to denote minor or local roads – eg Hebb Av, industrial Av, roads south of Marine Drive. 
As OSM doesn’t have a classification for non-residential local streets, I think “Residential” is the closest, but open to other suggestions – but I do think these roads should be classified.