+1 for Persona. Although you fight shadows and crawl dungeons, the other half of the game you go to school and live your life like an average japanese teenager. Try Persona 3 if you like dark, depressing stories, Persona 4 for happy stories. Both games are pretty good, although the dungeon crawling can get boring very fast and the games need an insane amount of hours to finish (60-100). If you like watching Let's plays I suggest that you try Giantbombs Endurance Run of P4 rather than playing the game itself. The guys who play the game make it highly enjoyable and you can always skip the boring dungeon parts.
I can't think on any other games with a focus on real life.. Maybe that Heavy Rain game on the PS3, but I haven't played that myself.