what theocracies of any religion haven’t “ended in tears”?

Part of me really is starting to wonder if giving folks who think they’re God’s special chosen people was a terrible mistake.

I think you missed a word or two there.

I’d suggest the mistake was giving people a country which was already occupied by other people. Whatever myth gets used to justify it, be it god’s chosen people or manifest destiny.