In my opinion the most offensive can be the names which indicate or show the superiority of one race over the other, indeed superiority of some group of people over the others.
The main thing that it don't reach the point of absurdity as in the example with the bear.