I remember playing Shadow Hearts without trying to save Alice and feeling this melancholy fall over me as she passed away on the train. It was quiet and subtle.

Kaim's reaction Lirum in Lost Odyssey was pretty sad. I think it's more the idea of continuing in this life alone, burying everyone you love that makes it sad for me.