Also leads to resentment. There could be internal resentment by the "diversity hire" to either himself, knowing he is the diversity hire. Or to the company, quietly thinking they dont think highly of him because he's the diversity hire.

And resentment from the coworkers, knowing he didnt fully deserve the spot and forcing them to work with her/him/xir/xim. Like a coaches son that has no business being on the team, let alone, be part of the starting squad. Just a jumbled mess of incohesion that shouldnt even be there.