I'd like to throw Starcraft 2 into the mix here (wings of liberty).
It may not be the most nonexistent, but it was definitely one of the hardest to connect with that really TRIED to connect with me.
The dialogue is painful, the events don't make that much sense, and the scale is constantly bizarre and off. You rescue a PLANET FULL Of colonists, and then deposit them somewhere else, where they establish a new settlement, only to have to rescue them again? 1) How long did this take to happen? 2) NO ONE saw this coming???
Further more, since you can do missions in odd orders, you'll get crazy intro/outro dialogue. Tychus and Raynor best of friends! And then Tychus suddenly turns on you calling you selfish and lazy... what...?
At least it had humor in it.