Please feel free to edit the question to clarify and elaborate it.
In numerous occasions, from the story of the Plagues of Exodus through wandering in the wilderness to his last gathering of Bnei Israel, Moses demonstrated two distinct types of leadership:
A Leader - Independent and decisive: (sort of "לא בשמים היא") taking responsibility to decide alone on acting or ruling a Halacha. For example, Moses appointing 77'000 Sarim after Yitro's advice.
A Prophet of Hashem's word - dependent and indecisive: (sort of "בשמים היא") Moses turns to Hashem to seek advice or Halachah, like in Bnot Zlofechad case.
I could not spot a pattern when he chooses a certain way over another, it looks inconsistent to me. Hence the question:
In what cases does Moses decide to act or rule Halacha on his own and when he decides to consult Hashem?