I've found there can also be an inverse of the "red but no traffic" problem where Google Maps is unable to understand that there can be multiple lanes traveling at different speeds on the same street. When I lived in SF I would always run into this at the freeway entrance on 5th and Bryant (shoutout to the worst intersection in the city). The two leftmost lanes going onto the freeway would be backed up for blocks but because the right lanes were open they would average it to a moderate traffic rating and would always want to route me to get onto the freeway via that shitshow.
I get that all the time in Vancouver. The lane(s) that eventually hit the bridge barely move, but get averaged with the flowing traffic in the other lane. Google Maps will always suggest taking two bridges on my morning commute.
Apple Maps seems to do a better job on this specific issue.