If there are any other non-sim games I am in love with, it's The Last of Us for the PS3. It's so packed with emotion and beautiful environments despite all the decay and various infected running around, and for once I have absolutely no complaints about the casting. It's just one of those games that keep you on the edge of your seat about to burst into tears either from uneasiness or witnessing a heart wrenching event, and it's impossible to put down the controller. Just one more chapter! Only, you can't stop there because oh shit everything's in a downward spiral and you have to see how it turns out!
If you have a PS3 and haven't tried this game yet, go do it. It's creepy and upsetting but believe me, you won't be sorry you picked it up.