Of course! I actually find Superman more relatable than most "dark" heroes like Batman or his ilk, because his upbringing and goals in life are very simple - he just wants to fit in, make friends, hold down a decent job, settle down with someone he loves, take care of his family, be a good neighbor and make a difference as best he can. I can't relate to being a billionaire genius playboy on a neverending self-destructive mission of justice, or a princess of an ancient warrior society, but I
can relate to that. His powers and alien origin just make most of these simple goals a bit more difficult for him.

And I like that he's more humble than most and open-hearted and that his first inclination in any conflict is to attempt to understand and relate to his opponent. He struggles with the most basic things that we all do, while others can only see him as a god. He certainly has flaws and vulnerabilities...they just aren't as often the physical kind.
I also find Superman stories more compelling than most because when you have such an extremely powerful being at the center, the conflict of the (good) stories inevitably becomes less about whether he CAN do something, but more about what he SHOULD do. So this gives way to some great and nuanced morality fables when in the hands of good writers.
Anyhoo, some of my favorite Superman stories:
-
Superman: Birthright by Mark Waid (this is the best take on Supes' origin story, imo, and an ideal introduction to the character)
-
Superman: Secret Identity by Kurt Busiek (an "Elseworld" tale, but a great one)
-
Superman: Up, Up and Away by Kurt Busiek and Geoff Johns
-
All-Star Superman by Grant Morrison
-
Superman Unchained by Scott Snyder
-
Action Comics by Grant Morrison
-
Action Comics by Greg Pak (especially Vol.5 "What Lies Beneath")
-
Superman: Rebirth by Peter Tomasi
Also, just for the record,
The Dark Knight Returns may be a good classic Batman story, but it is a TERRIBLE take on Superman. No one should get their impressions of this character from that book, imo.