I voted no since in most games it's either uneccessary or it just seems forced. That said I don't mind it at all if it feels natural like in The Walking Dead. Not too many games execute those lines as gracefully though.
Awesome games I've never finished: Vampire: The Masquerade - Bloodlines, Black Sigil, 999 (True ending), Nier (all endings besides A)
If its used in the right situation by characters that you would expect it from that's fine. GTA characters are going to swear and it makes sense for them to, If the next Mario game came out and all of a sudden Mario was swearing every time he jumped or was hit by a Goomba, then that would be stupid and unnecessary.