Put Azathoth for Tier 0. I will explain my reasonings for his "Tragic" ratiing right now.
So Lovecraftian horror where do I begin. To start the author had a pretty bleak and nihilistic mindset, and often expressed his own pains and struggles in his writing (I will not mention his racism in this).
There is a core concept of Lovecraft's writing and that is the fear of the unknown. Not just of the unknowing beings that reside beyond our comphrension, but the way people fear other people who are foreign to them. Theres a story I feel which perfectly portrays this theme. In his short story "The Outsider" it tells of a man who wishes to make contact and have friends, and so he seeks other people. But when they see him they run off in fear, never giving him a chance. The man in the end looks towards a mirror, and sees that he was a monster this entire time. Its a metaphor for how people can be demonized for simply existing, how people who are different or "Unknown" are feared by others and thus shunned as a result. Its the fear of the unknown, but also fearing you're part of that unknown which other's fear.
And I feel based on this, Azathoth is like the god we pray to asking for help that never answers. Azathoth is an eternal dreamer, sleeping dormant, incomprehensible to us in it's slumber. People pray to their gods all the time to seek salvation, yet nothing comes. When people pray to a god out there somwhere, they are praying to Azathoth. And Azathoth never answers their prayers. Azathoth is the absence of god, the nihilism that Lovecraft projects into his writing along with the many other themes he portrays. We try to give ourselves meaning, thinking we have some greater role to play in the world... When in reality our god does not care about us. It is absent from our lives, ignores our prayers, and never makes communication with us. And the dilemma about it is, if we don't have some purpose to work towards, some role to play. If our own creator that made us from his dreams didn't give us any purpose, if he doesn't care for us, then does life truly have any meaning?
This depiction of Azathoth being uncaring and absent from it's creations life also reflects onto Lovecraft's own personal life. His father died of illness, and so he was absent from his life too. His mother was stricken with grief that she never recovered from. Lovecraft also told of how close he was to his grandfather after death, being the "Center of his Universe". The man died later as well. He lost everything and no longer felt he had a reason to keep going. This is what Azathoth represents. Crippling Nihilism, exestential dread, and an absence of a god.