Honestly, he's closer to Ainz than Cid. He has a set goal and for the most part knows what he's doing. What he does not know is what happens AFTER he does something.
His ultimate goal is to keep the Sins in check by giving them a good childhood, of which he did very splendidly. He just doesnt...