Mass Effect pulls it off wonderfully. I can't explain it without intense spoilers, and I refuse to spoil something as amazing as this game for anyone.

It's deep though, and it really pulls you into the game because of the fact that all of the potential deaths in the game are based upon the outcomes of decisions you have to make.