Unfortunately, The Wall was the pinnacle of his success and things went downhill from there. The Final Cut had some merit, but he introduced politics into his lyrics that tainted the message. Worse still was The Pros and Cons of Hitchhiking, which was 40 minutes of self-absorbed burnt-out hippie whining. Had he chosen to retire before that release he could've taken a bow and commanded respect for the rest of his life. Instead, all of his utterances now boil down to, "Look at me! I used to be famous!"
I think you pretty much nailed it. No allusion intended.
Any thing Roger did solo was horrific. And I agree on the mental illness front. I and my oldest daughter suffer from Bi-polar and the music resonates with us so much. Especially the Wall and Shine on you crazy diamonds.