not usually but if i do get emotional, it will probably be with an rpg or something i would have put a lot of time into. three games spring to mind though
1) metal gear solid. that game had such an affect on me because i played it from start to finish practically non-stop so i got REALLY immersed. grey fox's last scene hit me like a truck and i think i almost shed a tear.
2) final fantasy 7. i played it when i was very young and i hadn't played a game like it before. i just got really attached to the characters - not aeris though, that whore.
3) metal gear solid 3. i don't even need to say any more than that. ;-;