How should a PhD student deal with an unprofessional and unhelpful advisor, who misses most scheduled meetings?
If you want me to take you at face value, it's not even worth completing the Ph.D. under your current advisor. You won't get a good problem, you won't get good guidance, you'll get stuck and won't get help, and you won't get a good rec letter for your next position.

That being said, a round of basic people skills may be helpful here. Have you tried asking your advisor such basic questions as how do they think your research is going? how can it be improved? You can even ask why they're frequently late. You can ask when would be better to meet, for instance.

That failing, the standard solution is to switch advisors, even though this is costly.

No, you can't really "go above" a tenured professor in any meaningful way, and even if you could, it wouldn't help you get sincerely better advising or a strong rec letter. Please research who else you can talk to though - another professor you trust who can advise you with some safety, resources through the grad school, etc.