I concur. I think a lot of non-Superman fans do not understand the nature of that sense of "Hope". In my opinion, it is the hope that we will move past our differences and work as a collective civilisation, superseding what Krypton achieved and what led to their doom and we will instead work towards a brighter future for us all. Where Kryptonian society failed, humanity will overcome its own obstacles and barriers to become a truly prosperous civilisation.
I do enjoy reading stories and seeing live action shows of Superman where he experiences moments of doubt, sadness and loneliness, but that's where the villains take advantage of vulnerable people in Superman's absence. For example in many iterations Superman was friends with Lex Luthor at the beginning. Lex is so incredibly clever that he is able to pull the wool over Superman's eyes and deceive Superman into believing that he is a benign humanitarian also, and despite being explicitly told by Jor-El that his mission on Earth would be a lifelong mission to lead by example and not to directly get involved in human society's politics and take sides with nations, Superman endorses Lex Luthor for the presidency of the US to only later realise what a big mistake he made. In such stories, Superman endorses Lex for the presidency, because he feels the burden of being the "messiah" and what he truly wants is to be "human", to have what his adopted parents had, to marry, settle down and be a farmer on the kent farm and raise children. In his almost desperate bid to relieve himself of the duty of being humanity's saviour he foolishly "passed on" this responsibility to Lex Luthor as US president only to later discover Lex's evil intentions for the world.