Hi there 👋,
Could you clarify what exactly you want to achieve in "game terms" supporting your engine mechanics explanation?
I paraphrase what I understood:
You have a micro planet which the player can rotate underneath the player avatar. While this is going, the player avatar is kept "globally" up right.
Some areas of the planet's surface are sticky like glue or Velcro and once the player rotates the planet under the player avatar and touches these areas, they will "stick" to the planet and move with the planet's rotation.
Once this happens the up vector for the player avatar changes and you want the avatar to be able to traverse the planet in any horizontal (as literally as in horizon) direction until they jump off again, keeping up right in respect to the planet not the "global" up axis.
Can you clarify my assumption? 😊