It isn't GTA, but Manhunt is a sweet game with loads of violence, stealth, and cursing.
The gameplay is sweet. THIS is urban horror. Wait till night, turn off the lights, lock the door, and play. The best and easiest thing to do is to execute the enemies (stealth kill them). When they spot you, you can sprint really fast, but makes lots of noise for other enemies to hear. Then hide in the shadows, where it's completely dark. When the enemy follows you, can't find you, then turns his back, go quietly behind him and slay him if you have a major weapon. The cool part is that you can feel Ear's heart beat when he is hiding.
The graphics are great. Just what is good for the console.
The game is really tough, but fun. Just don't let any little kids play it, 'cause it's obviously not for their age.