Ehat you said reminded me of Fate Stay Night, never played it, but the story was so good they made anime and manga for it, without the sex scenes of course.