Finding material that is off topic but preserved for some reason is often cited as a negative experience. The "I searched for XYZ and it was closed as not constructive" (note: not constructive hasn't been a valid close reason for several years).
This brings up the question of "should that material be findable on Stack Overflow if people are having such poor experiences when finding it?" and "are people finding the closed questions of yesteryear a disincentive to participate today?"
The finding things closed as a duplicate sign post isn't working as intended with redirecting them to the proper question - because when there is an answer to the question (that may or may not properly answer it) it prevents the logged out user from getting redirected to the duplicate.
The negative experience is that the interesting/useful questions/answers aren't rewarded.
It's bad that they are closed with harsh and false ("not constructive" on some of the most useful question there was...). It would be even worse if they were entirely removed so we couldn't find the answer.
As a non-white I call shenanigans. My non-whiteness is very obvious in my SO profile pic and not once in 8 years of active use of the site has it ever come up, nor have I perceived being treated any differently. Also, no one ever asked me if I felt “unwelcome” nor is there a button to click for that, so I don’t know where this really comes from...