Yeah that's a big fault with the game IMO. The amount of important, story-related missable content is staggering.
I'm very, very thorough when I play, although I don't use guides, to the point where I go back and talk to every NPC in the game after each major story event, and I still missed quite a bit of stuff even though the story took me about 120 hours to finish.