and at the time of the months where the moon is barely visible or not at all so the night is darkest.

Dovid HaMelech in Mizmor 30, Mizmor Shir  Chanukat HaBayit describes the rollercoaster ride he has gone through:
"I'll elevate You for you saved me and did not let my foes rejoice.My G-d, I cried out to you and you healed me.  O merciful G-d,You raised my soul from despair, You resuscitated me from the pit. Sing out to G-d and give praise to His Holiness. His anger lasts a moment and life is at His whim; in the evening/darkness tears lodge with me but in the dawn joy stirs.And I say in my serenity, I shall not fall again."
That is just the first half of the mizmor.
The second half reflects an even more precipitous cycle of feeling of abandonment, crying out to G-d and the ultimate salvation and offering of praise and thanks.

The Degel Makhaneh Efrayim on P' Ci Tavo brings down his grandfather,The BeSH"T's explanation for this mizmor. The BeSH"T likens this to a King who makes a maze of obstacles and partitions to instill awe in  everybody and to make access a little harder. Everybody knows the King is exalted and His dominion is total, His Light illuminates the worlds;however, the partitions and obstacles hide the King's visibility. Unbeknownst to almost everybody, the partitions are all illusory.

Heralds spread the word that whosoever makes it into an audience with The King, the King will reward him with all good things and will elevate him to be a courtier in the palace. Many are inspired by the promise of bounty, yet are deterred by the first obstacle. Others penetrate beyond the first few obstacles, yet turn back before the next, seemingly insurmountable obstacle. The King also places rewards along the way and many turn back after reaping those rewards, yet falling short of becoming a courtier in the palace of the King because they didn't face the next, greater obstacle.

However, the King's son is on fire to see his Father's face and the King's longing for the son's presence causes the King to evaporate these illusory partitions so the son may come closer. When that happens, the Son is in the House and the joy is unbounded.

CHaZ"L remind us all the time that 'ma'aseh avot siman l'banim' that our ancestors came before us and paved the way for us, their descendants. Surely, Dovid HaMelech is paving the way for all of Israel till Moshiakh is coming. However, he also is teaching us who came before him ==>> The first king/royalty from Avraham's lineage thru Ya'akov was Yoseif, viceroy of Egypt (mishneh l'melech Mitzrayim).  Nothing is coincidental.

We ALWAYS are reading the saga of Yoseif before,during and after Chanukkah. There are blatant phrases and similarities in Mizmor Shir Chanukat HaBayit that are mentioned in the Yoseif narrative - 'the pit' 'raising me up''hiding your face' 'mah betza"'you took me out of mourning into bing enveloped with joy'. Rebbe Nakhman says that Yoseif experienced the terrible rollercoaster to understand upon his release that he had had to go through it all as part of the process to reach the position of viceroy to Mitzrayim

May G-d always turn our despair into joy and bring the final Redeemer soon so we may again bring offerings to G-d in the Mikdash.