My current best guess is Java's checked exception silliness comes from the enterprise framework culture. Too much abstraction, architecture, cleverness, turgidity. I joke that Spring is an Exception obfuscation framework.
I've always really liked checked exceptions in my own designs. Though I'm not crazy about the syntax.