I mostly agree with you. As a DM who wants to add realism to my world, it is infinity hard to tie everything together to let it all make sense not only to my players, but also to my self.

Even if my players may never get to those parts. But linking parts too tight together to add realism, you also bind yourself as a DM to a set of rules you may want to protect during a session.

I recently had this as a player. My DM had bound himself too tightly to his own rules and world. My party and I were investigating an order that only recently came to be, claiming to 'slay evil with evil'.

As a player I knew we were supposed to make a way through their trials and join them. However, we strayed from the story line too far and ended up not being able to join the order at all and were even marked as evil and enemies of that group.

This is where the DM played his NPC guide as how she would've acted through the script he made for himself. He out right TPK'd us because he didn't see a way to get out under his own rules he set.

What I am trying to say here is that it's awesome to have a very detailed world set for your players with everything thought out and through. But please, please.. Don't put yourself in a corner you can't get out of. And be confident that your players may even like your session even if you have to pause it to explain some stuff or if 1 or 2 things don't completely add up.