Silent Hill 2 does not have a canon ending. Silent Hill 4: The Room revealed that James disappeared when he went to Silent Hill. Official statements from developers have kept the canonicity of the ending ambiguous. I like to think that "Leave" is the true ending, because it makes more sense to me.
Also, Fatal Frame II has a good ending where Mio saves Mayu but that goes against Fatal Frame III storyline.