I'm glad someone mentioned The Last Of Us, I know it seems like I have some weird sort of love affair with this game, you're right I do. It was amazing.

The fact that enemies react to sound means that you really have to sneak around because one false move and you bring everything in the area down on your head and chances of you fighting them off or escaping once that happens? Probably none existent. It's ridiculously tough at times. Weapons are a last resort, firearms will make a hell of a lot of noise which is bad because unlike most games where the enemies go where the bullet ricochets/impacts in The Last Of Us they head for the source of the sound I.E. you. You can use items like glass bottles or bricks to draw enemies away from your path, or if you're lucky you will have a shiv or two which means you can stealthily steal up on an enemy and shank them in the neck.

Perhaps luckily or unluckily, your companion characters whilst like most games depicts a suicidal tendency doesn't stupidly bring your enemies down on you 24/7 in fact their talk and back and forth disregards the rule of sound being how the enemies see which makes for a confusing moment as you're sneaking round a building worrying about the sound of your feet on the damn floor to hear someone shout "Hey" or similar at you.

Aside from The Last Of Us and of course Assasins Creed (so much love o nom nom nom) I would recommend the later splinter cell games. Conviction was good. Also Hitman Absolution.

There's more but I forget what ones right now.

PS. I loved MGS2.