I would say that the single best game I ever played was Planescape: Torment and it was definitely the narrative that made that game the success that it was.