I think morrowind is the gold standard for beeing offensive in video games.

Sure half of the insults were made up but they felt genuine.
You found yourself in a world where everyone resented you for beeing an outlander.
It was a world with slavery and all kind of nasty stuff.

And yeah, in general i think that beeing consistent with the world is important, but do not pander to people that take beeing offended to a political level. Nothing good ever came form that.