| Jonobi |
The issue I see with Tempest is that becoming cursebound 2 interferes with several of the domain spells you could pick, such as winter bolt and charged javelin. Even more specifically, bottle the storm gets its electricity resistance suppressed by your curse, making the Tempest Oracle exceptionally poorly-suited for using lightning domain spells. The rest of the curse is situational enough that you will often not feel its effects very much or at all, but if you're planning on using certain focus spells, this isn't the best mystery for it. On the flipside, if you don't intend on making any attacks and end up fighting in encounters with little to no electricity damage, you may as well have no curse at all most of the time.
I have seen the cursebound 2 condition of the Tempest mystery mentioned a few times as a large negative but isnt it a relatively minor one? The cursebound 2 gives a "-2 circumstance penalty to ranged attack rolls" but most (if not all?) spells use a spell attack roll which is a different thing. All types attack rolls have pretty explicit definition with very few exceptions... So I dont think the cursebound 2 condition would apply to much unless you were using a crossbow or something.
I havent played an Oracle yet but I am looking into making a Tempest mystery one and could see this point being brought up.