Elder Scrolls Daggerfall was surely the peek of this, you get a letter at the start telling you to meet a woman in a bar on a set date - turn up too early and she won’t be there, but if you mess around on sidequests and don’t have enough time to travel there so are late then she’ll leave and the main quest never really happens.
There were a million other ways to lock your ability to progress but I always remember that, I don’t know if it was possible to get back on track but I don’t think so, I probably played a thousand hours before I did a run where I even started the main quest