I think it all depends on the game world itself. The Witcher series is a perfect example of a world so gritty that it would feel odd NOT To have a ton of cursing, much of which would be familiar. Most FR games though, I honestly prefer the type of curses FR has developed over the years, racial, religious and so on. Most players comprehend comments about dwarves and beards, without much effort, for example, and they are colorful enough to get the point across.

Sorry, but I simply can't picture Elminster turning to one of the Seven Sisters and saying, "Shit, I forgot to bring fucking toilet paper for the magic outhouse."