it's hard to summon any motivation to get eyeball deep in dense Hebrew esoterica without knowing what tasty bits i'm looking for
This is true of any mystical-contemplative tradition: Hekhalothic (including Celestial Jerusalem), Merkavaic, Kabbalistic, Apocalyptic, Hesichastic… In a way the "tasty bits" are the whole of the tradition and you have to attack it as you would any other very large meal: a bit at a time. What you should be looking for is what I'd call a theography, that is, not an explication of the nature of the divinity itself (as in theology) but rather of the experience of unity with divinity, beginning from its first unfoldings and ending with a more or less personal eschatology of its last re-enfoldings, be them purely internal or subjective (as in, the personal enfolding of the mystic-as-god) or rarely as a speculative account of the end of times (particularly in Lurianic Kabbalah.)
That said maybe your questions have narrower answers: