SNATCHER did, and a lot of old adventure games do. Mostly text based and less interactive games.
Games like Chrono Trigger have endearing characters, but the story is pretty stupid. I enjoy FF7, but its story is nonsense. Fallout is interesting because of the freedom it gives you and the setting.
I'd say less than 10 games ever made have what would qualify as a "good, intelligently written" story.